How to do integration through import set using two target table

[Supriya Mane]

Hi Team,

how we can do integration using two target table

we need to create incident

1.if incident is not found create incident

2.if incident is empty then create incident

3.if mandatory fields are missing then incident will not create the incident show the error message

4.if incident state is new then create incident and associated task in incident_task table

5.if incident is present then create only task in incident_task table

6.if incident state is open, inprogress then create only task

how to achieve above through import set api

and for testing we are using source is postman

[Supriya Mane]

Hi  Team, 

Thanks for the update but i have one dought which table need to use for target incident or incident_task in import set and POST /api/now/import/u_incident_import_set you mentioned u_incident_import_set is this staging table or what?

[Supriya Mane]

In my Pdi create new import not there