Hello there.
I perform a successful List Row (dataverse) action in my flow, with a Odata search criteria that works and returns the single row with the information I'm after. Then I get lost with how to handle the result and extract the two column values i'm after. Below is a copy of the result, all I need to extract and use in a HTTP API call is "cr953_jobid": "ID_I_NEED_TO_USE", "cr953_jobname": "THE_NAME_OF_THE_JOB",
How do I achieve that please?
Cheers
Luke
{
"statusCode": 200,
"headers": {
"Vary": "Accept-Encoding",
"x-ms-service-request-id": "a665e70e-0eae-4433-8a4f-160079cbf697,7b19f289-d042-4559-aa7b-b190e1d8392a",
"Cache-Control": "no-cache",
"Set-Cookie": "ARRAffinity=ebd1cd1c8bc252fb361c8eda8598254cacbc7dca82fd4c42f359af54dee6fcd9; domain=domain.crm6.dynamics.com; path=/; secure; HttpOnly,ReqClientId=b2e76ffa-7dee-4017-91d3-376bb546d552; expires=Fri, 12-Jun-2071 05:59:41 GMT; path=/; secure; HttpOnly; samesite=none,ARRAffinity=ebd1cd1c8bc252fb361c8eda8598254cacbc7dca82fd4c42f359af54dee6fcd9; domain=domain.crm6.dynamics.com; path=/; secure; HttpOnly",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"REQ_ID": "7b19f289-d042-4559-aa7b-b190e1d8392a",
"AuthActivityId": "9b7210fd-1f7d-4618-b6dd-4e171e1f8a96",
"x-ms-ratelimit-time-remaining-xrm-requests": "1,199.34",
"x-ms-ratelimit-burst-remaining-xrm-requests": "5998",
"OData-Version": "4.0",
"Preference-Applied": "odata.include-annotations=\"*\"",
"X-Source": "1911481206875379911755108208363599121284017359153113125191366137711603811515058,141981412692311605614181108809716411228311631302501642191091882092322471741452390",
"Public": "OPTIONS,GET,HEAD,POST",
"Timing-Allow-Origin": "*",
"Date": "Sat, 12 Jun 2021 05:59:40 GMT",
"Allow": "OPTIONS,GET,HEAD,POST",
"Content-Type": "application/json; odata.metadata=full",
"Expires": "-1",
"Content-Length": "730"
},
"body": {
"@odata.context": "https://orgc9bd3046.crm6.dynamics.com/api/data/v9.1/$metadata#cr953_workflowmaxes(cr953_jobid,cr953_jobname)",
"@Microsoft.Dynamics.CRM.totalrecordcount": -1,
"@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded": false,
"value": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.cr953_workflowmax",
"@odata.id": "https://domain.crm6.dynamics.com/api/data/v9.1/cr953_workflowmaxes(cf5033a4-c9c8-eb11-bacc-00224817f386)",
"@odata.etag": "W/\"1142967\"",
"@odata.editLink": "cr953_workflowmaxes(cf5033a4-c9c8-eb11-bacc-00224817f386)",
"cr953_jobid": "ID_I_NEED_TO_USE",
"cr953_jobname": "THE_NAME_OF_THE_JOB",
"cr953_workflowmaxid@odata.type": "#Guid",
"cr953_workflowmaxid": "cf5033a4-c9c8-eb11-bacc-00154817f386"
}
]
}
}