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.
