integrating two tables

[Vedavalli]

Hi

If a incident is created then it should create a record in the custom table using flow and integration
How can we achieve  this?

Thanks in adavance

[Ravi Chandra_K · Accepted solution]

Hello @Vedavalli 

Create a trigger condition in flow when a incident gets created  (add any other conditions that specifies that it created from Incident)

Then you can create a custom table record. with mapping values.

Please Mark this answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra 

[Ravi Chandra_K]

Hi @Vedavalli

heres the approach I'm talking about.

There will be only one REST endpoint. The Response payload will contain the data for two tables.

we will get the response body and transform the data in to different tables.

This requires solutioning from source team as well. (oracle or fieldglass etc.,from where you are getting the data. If we have the required JSON paylaod, then its easy to populate the data into Two tables.)

follow the below thread where data is stored into three tables.

https://www.servicenow.com/community/developer-forum/can-we-store-data-in-multiple-tables-simultaneo...

Please mark this answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra.