NickT.68327 (Customer) asked a question.
Working with Workday RAAS report in Workflows
I am doing a GET to a workday raas report, and the data comes back in the body as a json, but i cannot parse the employeeID with a pluck, it always comes back with invalid list, i tried to do a list > construct and then do the pluck against employeeID but it comes back null. I think it has to do with the "Report Entry" header at the beginning of the json file not allowing each object underneath it to be its own object, anyone know of a quick way in workflows to update the JSON to remove the "Report Entry" snippet at the top and the corresponding ] and } at the end?
The data looks like this:
I was able to use replace pattern to remove all but the 1st [, it just says invalid regular expression, any insight would be much appreciated on how to capture the 1st [ and remove it
Nick, you should be able to parse a json object to pull the data you want. Unfortunately, what you gave me is a Screenshot and not the raw text so I cannot dump it into a Workflow and demonstrate a solution with your raw data.
You have an object: Report_Entry that you could first "Object Get".
This would leave you with a List of objects that you should then be able to pluck the employeeID from.
Here is an example:
@NickT.68327 (Customer) - Tim's solution above should work for you.
The list of objects in the report is contained within an object called "Report_Entry". If you use Object Get on your response body and a path of "Report_Entry", you should then be dealing with your list of objects from the report and the List - Pluck should work.