Using Process Variable in a Query Database From Integration

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

Parents Reply Children
No Data