Need help or suggestion on integration model

[Swetha Guligari]

Hi Team, 

I am working on Legal Service Delivery. We are going to connect servicneow with connecto. so the requirement is legal users use connecto tool to raise their Legal requests using intake form(Record producers). Same LR has to be created in Servicenow end. 

I was planning to use Import SET API. But the issue here is there are 12 record producers. If i create a single stagging table for all the variables i would need to create 200 fields on stagging table and write a transform script to convert the payload into respective LR. 

If i use scripted REST API i would need to have a custom table to store the payload. It's for internal verification if any data won't map.

The question is should i have single API for all the 12 record producers with single stagging table with 200 custom fields or each record producer to have each API ? or should i go with scripted REST API?

Please let me know how would i proceed further.

[DeependraS]

The best approach is to use a single Scripted REST API for all 12 Record Producers, passing a Record Producer identifier in the payload. Instead of creating 200 fields in a staging table, store variable data in JSON format within a single field, along with tracking fields like source_system and status. Use Transform Maps and Business Rules to dynamically process and map the data to the respective Legal Request (LR) forms. This approach ensures scalability, maintainability, and performance, making it easier to add new Record Producers without modifying APIs or tables. Storing raw payloads in JSON also helps with internal verification before mapping the data.

[Swetha Guligari]

Thanks for the information : after storing the JSON in a single field how would i process it using transform map. If you have any example code please help me with it.

[Ankur Bawiskar]

@Swetha Guligari 

go with scripted REST API and inform the 3rd party team to send the name of record producer along with payload

You can then search in your custom table for the variable mappings and submit record producer via script

check these links

Record Producer REST API

How to submit a record producer via rest api explorer 

https://developer.servicenow.com/dev.do#!/reference/api/xanadu/server/sn_sc-namespace/c_CatItem#CI-s... 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Swetha Guligari 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.