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.
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(); }