Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Import JSON DataSource- A list of Lists

rad2
Mega Sage

I have a JSON file, which is an array in the following format

[
	["test"],
	["test1"],
	["test2"]
]

How do i set the datasource settings so i get three records in the import set

5 REPLIES 5

Community Alums
Not applicable

Hi @rad2 ,

You can to Use 3 different import set tables to import data and process the data using the transform map.

 

Ankur Bawiskar
Tera Patron
Tera Patron

@rad2 

you can use data source with type -> File and Format as -> JSON

You need to specify the path so that system knows the root

JSON file import examples 

AnkurBawiskar_0-1741855507841.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@rad2 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

rad2
Mega Sage

Hi Ankur, 

I have found that it is directly not possible to parse a List of Lists JSON in the DataSource. so used a script function to do that