Let me make it more simple. Rather going to the powershell script, lets first get the data into ecc queue and try to parse it with a business rule, (this is temporary testing, after that you can add more optimization).
1. Identify the path of file you want to read. I am taking an example of dummy file I created in my instance. I used a existing mid server folder i.e. /agent/ and created a directory "testRead" in the "agent" folder. And created a dummy JSON file in it with name "test.json".
Also added some content in the json file:
2. Now open the "ECC queue" in ServiceNow instance "ecc_queue" and create a output record as shown in below screenshot:
3. Keep refreshing the page until the output is processed and you get an input record in the related list.
4. Once you see the record in related list, Open the record. It will have the status as error because there is no sensor defined to process the data. You can ignore the state for now. Check whether you are getting the json file content in the Payload.
Now you know that you can bring the json file data. This methods can be optimised using the processing sensor to parse the output, use the BR to identify the type of record and process the data, using the MID Scripts Files and MID Script Include, using the Integration HUBs.
If more help is required, kindly let me know.
Regards,
Parag Sanyashiv
