Hello everyone. We have a requirement to fetch mul...
# advice-data-ingestion
d
Hello everyone. We have a requirement to fetch multiple reports from workday using SOAP connector. I am able to create a protype to fetch one report from Workday. I am using below mentioned static files to request and process the response" 1. Use static xml file to make the request. 2. The xml response received in step 1 is then processed using a static xsl to cherry-pick desired fields and flatten the response. 3. File produced in step 2 is validated against a static JSON schema. Although my prototype works fine, as next step I need to modify it to be able to fetch other reports as well using same connector. To do so, as first pass I am planning to pass xml(to make request payload), xsl and JSON schema as parameter in UI. I m aware of the fact that above solution is not sustainable as business requirement changes frequently and we might need to fetch more columns and ideal solution would be to persist entire response from workday. 1. While I am working on parameterization solution (passing xml, xsl and JSON schema via UI), it would be great if anyone could share their experience regarding limitation of this approach or any problem they would have encountered. 2. Also, my ultimate goal is to be able to generate XSL(to flatten the response) and JSON schema dynamically for each report. Can anyone help me with how to generate dynamic JSON schema for SOAP connector.