How to import json file to mid server

[Sprankle]

@Ankur Bawiskar 

I have secanrio to import json file to mid server

[AJ-TechTrek]

Hi @Sprankle ,

Request you to please share the more info and scenario for that , so I can help you.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

[Sprankle]

Hi,I have scenario to get  json file from mid server to servicenow instance (json file should contain the data of table fields i.e (number,id of business application table).

[Rahul Priyadars]

You Can try using data Sources Option in Service Now where File Format is JSON. SS for ur reference.

Using File Type and File Retrieval method you can try loading the file data into Service Now.

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/referen...

Regards

RP

[Parag_Sanyashiv]

Hi Sprankle,

I don't think that there is straight forward method to do this, but what I can suggest you is:

1. Make use MID Server Script Files and create a Powershell or shell script which has instruction to read the json file.

2. Make use of scheduler which will create a output record in ECC queue to call the Powershell or shell script and gather the information of json file as ECC input. OR you can use the Powershell Step from Flow Designer too and write other parsing logic in a flow designer action.

3. For ECC queue input you can create some post processor scripts/sensors or BR that will read the file content retrieved in the ECC queue and parse it according to the need.

Regards,

Parag Sanyashiv