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

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.
Highlighted
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 Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch