One Star

How to get auto-generated GUID id when using tSugarCRMOutput insert?

I am inserting new SugarCRM accounts using the tSugarCRMOutput component.  The insert works just fine.  However, what is a convenient way to get the auto-generated GUID id created by SugarCRM?  I need this id to insert related records in other modules.  My guess is:
Job 1:  Insert all new SugarCRM accounts using the tSugarCRMOutput component.  Insert unique_key from my database into a custom account field in SugarCRM.
Job 2:  Use tSugarCRMInput command to read all accounts inserted with today's date and unique_key is not null.  Write those account ids to my database table.
Optimally, I could use an output variable within tSugarCRMOutput to get a returned id, but I suppose this isn't' possible.  Thanks.
1 REPLY
Five Stars

Re: How to get auto-generated GUID id when using tSugarCRMOutput insert?

I'm not sure if you're asking if your GUID can be generated inside SugarCRM; but you can easily generate UUIDs in Talend by creating a simple code 'routine'.
import java.util.UUID;
    public static String getUUID() {
    return UUID.randomUUID().toString();
    }