Large JSON Objects - Workflows

Questions
1

We are pulling from our Workday API and get about 4000 results in a single Object with numerous keys and values in each Object. We need to be able to pull two key value pairs from each result and update our Okta schema based on user data. The issue I’m running into is that the object response is a large array:

{
 "Report_Entry":
[
  {
  "Employee_Type": "Employee",
  "Field1": "foo",
  "Field2": "bar"
  },
  {
  "Employee_Type": "Employee",
  "Field1": "foo",
  "Field2" : "bar"
   }
  ]
}

I’m able to get the two fields when testing with a single object, but getting the key value pairs from multiple objects seems to be more difficult than I thought. Any ideas or tips?

2

I have figured this out. I was having troubles iterating through a list and didn’t see the drop down option in the For Each item list.

2 Likes
3

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.