topic Re: Retrieve Item from Object in Pipelines

Retrieve Item from Object

MOVC — Wed, 11 Oct 2023 12:10:43 GMT

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.

Re: Retrieve Item from Object

NandanHegde — Wed, 11 Oct 2023 12:58:35 GMT

Hey,

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

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

Re: Retrieve Item from Object

MOVC — Wed, 11 Oct 2023 13:02:56 GMT

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.

Re: Retrieve Item from Object

ajarora — Wed, 11 Oct 2023 21:59:38 GMT

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

Re: Retrieve Item from Object

MOVC — Thu, 12 Oct 2023 08:40:16 GMT

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.

Re: Retrieve Item from Object

MOVC — Thu, 12 Oct 2023 08:57:43 GMT

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.

Re: Retrieve Item from Object

MOVC — Thu, 12 Oct 2023 09:11:59 GMT

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.

Re: Retrieve Item from Object

v-cboorla-msft — Thu, 12 Oct 2023 12:43:56 GMT

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.