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.
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.
v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi MOVC 

 

Thank you for using Microsoft Fabric Community.

Glad to know that your issue got resolved. Please continue using fabric for help regarding your issues.