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, Can someone please give some suggessions

[Prabu Velayutha]

@Sruthi17  SOAP integration uses SOAP messages to pull the data from the Workday WSDL. You need to check the WSDL response check if you can find the field already part of the response, if it is already part of the response you need to update the data loader script used in the Scheduled import job to map and load the field value to the staging table. I will check if can share some samples if you need.

If my response helps to solve your issue. Kindly mark it as helpful & correct.

[Sruthi17]

Hi @Prabu Velayutha ,

Thank you for your response.

Should I check for the field in the WSDL XML in the SOAP message?

Or should I check for the field somewhere else?

Could you please help me figure out this?

[Prabu Velayutha]

Hi @Sruthi17 

Yes you can find it in the WSDL XML of the SOAP Message in the XLM tag. Also if you have a get SOAP message functions you can test it and check if you get values in the response, please find the reference screenshots below for testing.

Revert if you have more questions.

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