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

Anonymous — Wed, 20 Apr 2016 19:39:08 GMT

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.

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

Anonymous — Thu, 21 Apr 2016 08:44:46 GMT

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

topic How to get auto-generated GUID id when using tSugarCRMOutput insert? in Talend Studio

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

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