The CreatorCon Call for Content is officially open! Get started here.

Import Sets JSON files "Path for each row" missing

Jamie Cockrill
Giga Contributor

Hi, I'm new to ServiceNow development so if this has an obvious answer I apologise in advance.

I'm trying to create a Data Source so that I can use Import Sets and Transforms to load data into ServiceNow. I seem to be failing at the first hurdle which is to create a valid JSON File Data Source.

I have seen the following documentation pages:

  • https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/reference/r_FileTypeDataSource.html
  • https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/reference/json-data-source-examples.html

And I appear to be missing is a "Path for each row" field on the form which enables me to tell it where to find the array root element. The field is not appearing for me at all, even if I select the 'Personalize Form' control on the form itself.

find_real_file.png

This is my second Personal Developer Instance, having reset my first thinking that I could've screwed up the instance somehow. All I have done since getting each instance is to install Vulnerability Response. I have made no further changes.

What I would like to understand is to how to create a JSON File Data Source in the absence of the "Path for each row" field in the UI. I'm happy if there is another way, I just can't find documentation associated with that.

Thanks,

Jamie Cockrill

1 ACCEPTED SOLUTION

I've tested it in Rome and San Diego. in San Diego - Please add "Path for each row" to "Default view" else try it from list view to update the value of column "Path for each row".

For your reference.

find_real_file.png


Thanks & Regards,
Vasanth

View solution in original post

11 REPLIES 11

Hitoshi Ozawa
Giga Sage
Giga Sage

Hi Jamie,

Would appreciate if there is a sample JSON file to be used as a data source.

Jamie Cockrill
Giga Contributor

Hi Hitoshi,

I've attached a sample as requested.

Thanks,

Jamie

Please try to set Path for each row (Try it from native platform portal instead of studio). Used sample attachment provided by you

find_real_file.png


Thanks & Regards,
Vasanth

I can't see the header to see if I'm using the same interface, but I get the same result outside of Studio as well.

Are you using San Diego or a different version?

find_real_file.png