API/XML Mapping with CSV file using azure data factory getting error message

Question

API/XML Mapping with CSV file using azure data factory getting error message

Rajeev Gupta 0

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,'

QuantumCache 20,681 Reputation points Moderator

2024-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,681 Reputation points Moderator

2024-02-23T07:28:18.7933333+00:00
Rajeev Gupta

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,681 Reputation points Moderator

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!