Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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