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

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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download