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, "recordsAffected": 0, "resultSets": [ { "rowCount": 1, "rows": [ { "MaxMod": "2023-01-01T00:00:00Z" } ] } ], "outputParameters": {}, "outputLogs": "", "outputLogsLocation": "", "outputTruncated": false, "executionDuration": 55 }

 

I was trying to use the output, along the lines of:

 

@first(activity('Get Max Mod').output.resultSets) since each the response is an array, but each line in the array is an object so I can't do @first(activity('Get Max Mod').output.resultSets.rows) or anything.
 
It's probably straightforward but I just can't see it.
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.

7 Replies

  • 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.

  • ajarora's avatar
    ajarora
    Microsoft Employee
    2 years ago

    Did you try `@first(activity('Get Max Mod').output.resultSets[0].rows` ? 

    • MOVC's avatar
      MOVC
      Resolver I
      2 years ago

      Didn't work, got the same "Can't put an Object into a string variable" error message. If I do @first(activity('Get Max Mod').output.resultSets[0].rows[0].MaxMod) then the activity succeeds but the stored value is just "1" and not the date/time I need. 

      • MOVC's avatar
        MOVC
        Resolver I
        2 years ago

        I switched the activity from Script to Lookup which got me what I need. I used the same query then 

        @activity('Get Max Mod').output.firstRow.MaxMod with the "first row only" option ticked worked. But there still should be a way to do this with Script activities.