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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get Salesforce ID

I need realize this simple flow:
1) I must read records from a mysql table
2) I must insert this data (i can use tMap) in Salesforce object
3) I must update the opriginally record in mysql table with salesforce record ID 
What I can do? how can I get the salesforce id and update table column of originally record?
Can you help me?
Benny
Labels (3)
5 Replies
Anonymous
Not applicable
Author

Hi,
From you description, you can design your job as:
tMySqlInput(read records from a mysql table)-->tMap(further processing)-->tSalesforceOutput(insert this data in Salesforce).
3) I must update the opriginally record in mysql table with salesforce record ID

Could you please set an example with input and expected output for us?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina,
 in the image you can see an example of expected output  
0683p000009MC00.png
Anonymous
Not applicable
Author

Hi,
hello, have you some news for me?
P.s. please ... please ... :rolleyes::rolleyes:
tamilselvan1
Contributor
Contributor

any solution ?

TRF
Champion II
Champion II

Clear Extend Insert checkbox From Advanced Settings then tick Retrieve Insert Id option.
This will have you salesforce ids after Insert operation. Then you can update original records.