How to use XML API in Azure Data Factory or in Azure Synapse?

Anonymous

I am trying to integrate data from a third party's API.
They use XML API.

Bottom is graphic illustration of web services of this company

This is their web page regards to Web Services.
https://developer.intacct.com/web-services/

Since I do not want to use SDK (because I might have to use VM and install SDK), I am trying to use XML API.

My company uses Azure Data Factory (ADF) and I would like to know whether (and if works, how) XML API works in ADF.
Other option might be using Azure Synapse (if XML API works better).

Does XML API work with ADF?

Where do I find more information?

Thanks.

Dervishi, Erald 66 Reputation points

2022-03-07T19:48:05.853+00:00

@KingJava Were you able to find any solutions for this?
I have a similar scenario using
https://developer.intacct.com/web-services/
Please let me know if you have any recommendations.
Thanks
Anonymous

2022-03-07T21:33:50.927+00:00

@Dervishi, Erald
I ended up using Azure Function (Http Trigger) to pull data (using Visual Studio C#), publish each of them and then use Azure ADF (not Synapse).

I wish I could share some of my previous posts in this community site, but it appears that it only show last 30 days.
https://learn.microsoft.com/en-us/users/kingjava/

I saved these URL on my browsers:
https://learn.microsoft.com/en-us/answers/questions/700102/how-to-scale-out-the-size-of-data-moving-using-azu.html
https://learn.microsoft.com/en-us/answers/questions/693094/how-to-get-rid-of-34-from-json-file-at-the-beginni.html
https://learn.microsoft.com/en-us/answers/questions/679795/azure-data-factory-timeout-error-34500-the-request.html

This video saved me:
https://www.youtube.com/watch?v=lSLnffz3_1M&list=PLHdddESbFFCKyPvEJ56oisGTErSgFvTw_&index=2

C# code for the VS solution
https://github.com/kudohs/cs

Enjoy the journey.
It took me a while to create pipelines.
Dervishi, Erald 66 Reputation points

2022-03-08T14:55:02.17+00:00

@KingJava Thank you for the information provided, is funny but I have exactly the same scenario as yours with listing vendors, etc.
Is it possible to provide the pipeline structure you followed to resolve this? I need to insert all the data from different calls max 10 to SQL tables.
also, another question I had were you able to perform POST calls to the endpoint URL?
I have another requirement that needs to POST data from SQL table to Intacct endpoint URL using their APIs.
here is my personal email if need it. dervishi.erald23@Stuff .com
Thank you for your help.
Anonymous

2022-03-08T17:23:43.297+00:00

@Dervishi, Erald

If you look at all the URL that I mentioned you will see the pipeline structure.
https://learn.microsoft.com/en-us/answers/questions/693094/how-to-get-rid-of-34-from-json-file-at-the-beginni.html
Sorry, I cannot help you more..

I am not sure about bottom:
POST data from SQL table to Intacct endpoint URL using their APIs.

I think the best way to get help is just posting on this board.
Microsoft technical engineers are really good at following up with your question.
It usually takes about 1-3 days (average) for them to respond, or could be longer (up to a week).
When you post your question, do not forget to tag 'Azure Function' and technical platform you are dealing with.
Anonymous

2022-03-29T18:38:08.247+00:00

@Dervishi, Erald
If you want to read all my posts, please go to
https://learn.microsoft.com/en-us/users/kingjava/qna

Accepted answer

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-10-28T01:54:09.98+00:00
Hello @KingJava ,
Thanks for the ask and using Microsoft Q&A platform .

On the reading the link which you shared

Content-Type
All data should be sent encoded as XML with a Content-Type of application/xml. Sage Intacct currently does not support receiving JSON through Web Services.

The ADF REST connector only supports JSON response

"For REST as source, copying the REST JSON response as-is or parse it by using schema mapping. Only response payload in JSON is supported."

https://learn.microsoft.com/en-us/azure/data-factory/connector-rest?tabs=data-factory#supported-capabilities

Please do let me know how it goes .
Thanks
Himanshu

-------------------------------------------------------------------------------------------------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Please sign in to rate this answer.
Dheeraj 351 Reputation points

2021-10-28T10:03:49.6+00:00

What about this link ? could this work?

Anonymous

2021-10-28T16:43:08.36+00:00

@Dheeraj Thank you for your response. Yea, by looking at the URL, it appears that ADF supports XML format. But I am curious whether it accepts XML API. @HimanshuSinha-msft , what is difference between what you implied earlier saying "the ADF REST connector only supports JSON response" and what this article indicated? Thank you both of you.

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-11-01T22:30:45.247+00:00

Hello @King, James

When you mentioned API , I am assuming that you send request and get response with the desred results . My interprration to the ask was that your response is always in XML and not in JSON . What @Dheeraj posted a different ask , XML is a supported file type if you are copying data from a XML file stored in the cloud storage mentioned in the article .

Thanks
Himanshu
Sign in to comment

How to use XML API in Azure Data Factory or in Azure Synapse?

0 additional answers