I have an integration that I save the output into a DataSubset object and want to use to update a table in the database with a Query Database task.
The DataSubset is as followed:
DataSubset startindex null ... data [List of Dictionary - 1,000 items] Dictionary EMPLOYEE_ID "1" PAY "Hourly" ...
In my Integration task, which is the first task, I save the output to a Result variable (which is type of DataSubset).
Now in the next task, I add a Query Database task that I want to use to update a table where the EMPLOYEE_IDs match
Would it be: "Update users set pay = ac!Result.data.PAY where employee_id = ac!Result.data.EMPLOYEE_ID;"?
This doesn't seem to work. What am I doing wrong or what's the right way?
Discussion posts and replies are publicly visible
here2learn said:This doesn't seem to work
This does not provide much details we could somehow try to guess what the issue might be. Can you shed some light on this?
Hi Stefan, what doesn't work is the query I added in the SQL Statement as "UPDATE pay from users where employee_id= ac!Result.data.employee_id;"