question servicenow integration in Community Central forum

servicenow integration

Venkumahant — Mon, 24 Feb 2025 16:32:09 GMT

i need steps to create import and transform map, can anyone help me.

Re: servicenow integration

Rohit Singh — Mon, 24 Feb 2025 16:50:53 GMT

navigate to "System Import Sets", create a new Import Set table to match your external data source structure, then go to "Transform Maps" to define the mapping between the import set fields and the target ServiceNow table fields.

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

Refer this video

https://www.youtube.com/watch?v=9v6LQy1Mff4

Re: servicenow integration

Venkumahant — Mon, 24 Feb 2025 16:51:12 GMT

com.glide.db.impex.datasource.DataSourceException: Connection URL cannot be empty. i'm getting this error

how to fix this ?

Re: servicenow integration

Rohit Singh — Mon, 24 Feb 2025 16:55:37 GMT

Hi @Venkumahant

When are you getting this error. Please elaborate.

Re: servicenow integration

Venkumahant — Mon, 24 Feb 2025 16:57:20 GMT

after trying to import an excel sheet to create an import set

Re: servicenow integration

Venkumahant — Mon, 24 Feb 2025 16:58:38 GMT

Re: servicenow integration

Sandeep Rajput — Mon, 24 Feb 2025 17:01:13 GMT

@Venkumahant What is your file retrieval method for the data source?

Re: servicenow integration

Rohit Singh — Mon, 24 Feb 2025 17:05:12 GMT

Hi @Venkumahant

Hope you loading the file in the right table. Refer the video thoroughly which I have shared and go through each step.

System Import Set -> Load Data

Refer snip below

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

Regards,

Rohit

Re: servicenow integration

Venkumahant — Mon, 24 Feb 2025 17:18:34 GMT

Re: servicenow integration

Venkumahant — Mon, 24 Feb 2025 17:18:53 GMT

no luck

Re: servicenow integration

Rohit Singh — Mon, 24 Feb 2025 18:12:30 GMT

Hi @Venkumahant

Please make this business rule "Build Connection URL" on the data source table as active and then try.

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

Regards,

Rohit