Forum Discussion

MOVC's avatar
MOVC
Icon for Resolver I rankResolver 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
Icon for Resolver I rankResolver 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
Icon for Resolver I rankResolver 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
    Icon for Microsoft Employee rankMicrosoft 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.