Data Source - Import Error

[MMT3]

I am trying to pull records from a web service (JSON file) created by a Workday developer so that I can update fields on a specific table within ServiceNow with Workday data.  I created a Data Source file to pull the data into a temp table and I am expereincing an error message.  I added screenshots of the data.  If anyone could help, I would greatly appeciate it/you.  Thanks.

[-O-]

Path for each row should be /Report_Entry/Report_Entry (vs. /results/results).

But you will run into different problems.

The JSON data is not a flat table, but contains child records too.

A simple data source will not be able to handle that.

I'm talking about path /Report_Entry/Purchase_Orders_group/Purchase_Orders_group/.

It may be that you need to create a REST Message, fetch the JSON using some script and place that data into multiple import set row tables.

Perhaps even use Robust Transform Maps vs. Transform Maps.

Unfortunately the data makes no sense to me so I can't be more concrete.

[-O-]

Did some testing at it seems even with updated Path for each row settings the JSON won't load because of the above mentioned divergence in the structure; the Purchase_Orders_group nodes on the same "level" as the Report_Entry nodes is a no go.

Removing the Purchase_Orders_group node from the JSON makes it all work fine (and using the correct Path for each row setting).

[Jason-H]

Hi MMT3,

Were you able to find a solution for this? I'm running into the exact same error with my Workday report.

Thank you!