Workday Integration

[Sruthi17]

Hi Experts,

I have a small doubt explained clearly below, please help me.

There is a scheduled job that runs everyday to pull data from workday to servicenow. Uses a SOAP integration. The data from workday is stored in a staging table and using transform map, data is mapped to the target table. 

My doubt here is in the staging table there are many fields, and I also want to bring a new field from workday, but I am not sure where/how to bring this new field from workday to servicenow staging table.

Can anyone suggest me where I need to check.

[Sruthi17]

Hi @Prabu Velayutha

I am able to find the required field in the WSDL XML, now how can I pass the field value to the staging table 

Thank you so much for your help

[Prabu Velayutha]

Hi @Sruthi17,

You can find the data loader script in the respective import schedule job. Is this custom integration or using OOB connector?

Script include may be used for executing the SOAP Message and loading data to import set table  and  this may be called in the Import schedule script and that script include needs to be updated with the field name mapped with the import set field, or it may be a script, there are multiple approaches depends on what they used in your instance.

You can can add these new field in the script like other fields were mapped.  You may need to create the field in the import set table for mapping this new field from work day feed in the script.

After mapping the field in the import set table you need to update the transform map or transform script to map the field from import set or staging table to Target table field.

Revert if you need more clarification also let me know the approach used for importing and mapping the data to the target fields.

Mark this as Helpful and Accept the Solution if my response helps to solve your issue