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.
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.
      • MOVC's avatar
        MOVC
        Resolver I
        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.