Importing data into staging table from REST api
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2024 05:40 PM
I am trying to load data into servicenow from external source and load into a temp table. From there I will be writing a transform map to update another table.
Should this be set up as Import Api or inbound integration?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2024 07:09 PM
When setting up data import in ServiceNow, whether to use Import API or Inbound Integration depends on the specific requirements.
Import API:
- The Import API is used to import data from an external source into an import set in ServiceNow. This data is temporarily stored in a staging table (import set), and then you can use a transform map to update other tables.
- If your use case involves importing data into a temporary table before processing it, the Import API is generally the best choice.
Inbound Integration:
- Inbound Integration is used to set up data exchange between ServiceNow and an external system, either unidirectional or bidirectional. It can handle more complex data flows and can also push data from ServiceNow back to the external system if needed.
- It is more suited for complex or ongoing integrations.
Conclusion:
Given your workflow, where you want to load data into a temporary table and then use a transform map to update another table, Import API is the appropriate choice. This will make managing the import and transformation process more straightforward.