Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,365 questions
API/XML Mapping with CSV file using azure data factory getting error message
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 14.000000000000002%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rajeev Gupta
0
Reputation points
I am facing issue while extracting API/XML data using azure data factory....giving below error message ErrorCode=UserErrorInvalidPluginType,'Type=Microsoft.DataTransfer.Common.Shared.PluginNotRegisteredException,Message=Invalid type 'XmlFormat' is provided in 'format'. Please correct the type in payload and retry.,Source=Microsoft.DataTransfer.ClientLibrary,' Step I followed -
1 - Created LS using HTTP service, tested URL it works
2- Created DS for source using (Generic protocol) HTTP - XML and given URL , tested looks fine
3 - Created DS for Sink as CSV/Parquest service
3 - Created copy activity added source detail and verified with Preview data, looks fine
4 added sink detail.
now while debug it throwing error message -
ErrorCode=UserErrorInvalidPluginType,'Type=Microsoft.DataTransfer.Common.Shared.PluginNotRegisteredException,Message=Invalid type 'XmlFormat' is provided in 'format'. Please correct the type in payload and retry.,Source=Microsoft.DataTransfer.ClientLibrary,'
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,346 Reputation points2024-02-16T20:43:00.4866667+00:00 Rajeev Gupta Is the XML well formed? Can you please attach the sample XML file which you are using? Please try with other XML files and do confirm if the error still exists? Dataset properties XML as source
-
Rajeev Gupta 0 Reputation points
2024-02-20T08:52:21.7+00:00 Hi SatishBoddu-MSFT,
XM is well formated, no issue with XML, now using copy activity I can copy data data but only first record copied, there are many record, nested record, that need to copy. some other reference I tried with data flow but getting message dataflow not support http linked service service .... Thanks for your reply -
QuantumCache 20,346 Reputation points
2024-02-23T07:28:18.7933333+00:00 - Please attach sample XML files , so that we try the repro ?
- Attach the Dataflow Pipeline screenshot, so that we know exactly what activities are used?
Please add or attach any other sample files or info which are needed to help with?
-
QuantumCache 20,346 Reputation points
2024-02-26T21:16:16.77+00:00 Rajeev Gupta Just checking if we are still connected on this discussion? Please let us know the sample Data/files so that we better assist you!
Sign in to comment
Sign in to answer