Is there a way to receive the payload of post scripted rest API in the ECC queue?

[Neeraj1]

Our requirement is to get the JSON payload in ECC queue which is coming from a third party consumer by using the POST scripted rest API created in ServiceNow.

1. Is that possible?

1. How to achieve this in ServiceNow?

[ersureshbe]

Hi, May I know why you are referring the ECC Queue.

If 3rd party data coming to service now then you can use import set table - it will fulfill your requirement.

Import set table will parse the JSON automatically based on your field transformation mapping.

Please mark as correct answer if it helped.

Regards,

Suresh.

[Neeraj1]

May be it is a stupid question to ask-

1. We need this integration for the multiple questionnaire templates for the GRC vendors, do you think that import set table will be able to parse the data ?

2. Could you please share the details how to parse the JSON using import set table, as I haven't seen anything like this in past, if this works then it would be a great help.

Thank you in advance!

[ersureshbe]

Hi,

There is OOB behaviour when data is send as JSON format with this import set table it will parse automatically.

For example- {'u_name':'test', 'u_id':'test id'} This payload having the 2 custom fields. When this transaction received in importset table as per functionality it will parse automatically and send to target table fields depends your field mapping.

Regards,

Suresh.

[ersureshbe]

Hi, 

You can see many videos how to use import set table in Youtube and service now communities. Can you refer the same.

I'm not sure what data structure the 3rd party is sending and  what is the design planned.

But import set table approach is simple and efficient but we should change the approach based on the payload data structure.

Regards,

Suresh.