You can use a web service connector for Source transformations, such as Workday v2.
Data that comes from a web service typically has a hierarchical structure. For example, when you use a Workday v2 source connection, the data passes as XML with a hierarchical structure.
When you select a web service connection for a Source transformation, you perform the following steps to configure the transformation:
Select the web service operation.
Customize the request message to filter unneeded data out of the data flow.
Map the hierarchical data structure to a relational structure.
For example, you want to include worker information from Workday in a mapping with a relational database target. You create a Source transformation and select the Workday connection. You select the Get_Workers operation, which pulls the worker data in a defined XML structure. You define an advanced filter so that only name and contact information enters the data flow. You define a relational structure for the worker data and then map the fields to fields in the target database.