Forum Discussion

MOVC's avatar
MOVC
Resolver I
2 years ago
Solved

Retrieve Item from Object

What's the syntax for getting something out of an Object to store in a string variable? I use a script activity to return a single value from a data warehouse:   { "resultSetCount": 1, "recordsAffe...
pipelines
  • MOVC's avatar
    MOVC
    2 years ago

    Found it!

     

    @activity('Get Max Mod').output.resultSets[0].rows[0].MaxMod
     
    I guess the first() breaks it. Thanks for pointing me in the right direction.
NandanHegde's avatar
NandanHegde
Super User
2 years ago

Hey,

Do you mean to say the below is your activity output:

{ "resultSetCount": 1, "recordsAffected": 0, "resultSets": [ { "rowCount": 1, "rows": [ { "MaxMod": "2023-01-01T00:00:00Z" } ] } ], "outputParameters": {}, "outputLogs": "", "outputLogsLocation": "", "outputTruncated": false, "executionDuration": 55 }

 

and what value are you excatly after? can you highlight the part and your desired output so it would be clear to us?

BUt based on my understanding, you can select a specifc array and then iterate it over via for each else you can convert the output to string using string function

MOVC's avatar
MOVC
Resolver I
2 years ago

Apologies if I wasn't clear, I need to store the value '2023-01-01T00:00:00Z' in a string variable (set variable activity) and I need to know what I need to enter into the Value field (Pipeline expression builder) in order to do that.