0

I am trying to call the Rest Api from Jira via the REST Connector of Synapse. I always get the error 21155. Error occured when deserializing source JSON file. Check if data is in valid JSON. Unexpected character encountered while parsing value <Path", line 0, position 0.

Does anybody know how to solve this problem?

I checked in postmen and there it worked and the result is a valid json.

Felix111
  • 1
  • Can you share rest Api or its Output to verify and detect the problem – Pratik Lad Nov 23 '22 at 10:01
  • @PratikLad the output is: ErrorCode=JsonInvalidDataFormat,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error occurred when deserializing source JSON file ''. Check if the data is in valid JSON object format.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Newtonsoft.Json.JsonReaderException,Message=Unexpected character encountered while parsing value: <. Path '', line 0, position 0.,Source=Newtonsoft.Json,'" – Felix111 Nov 23 '22 at 10:46
  • May be your data format is invalid JSON format, ADF can't help you handle the illegal deserialization. According to the connector [doc](https://learn.microsoft.com/en-us/azure/data-factory/connector-jira?tabs=data-factory),ADF supports JIRA connector.Maybe you could try to have a try on that. – Pratik Lad Nov 23 '22 at 12:29
  • I solved this isseu by using the http connector – Felix111 Nov 30 '22 at 15:49

1 Answers1

0

I tried to reproduce your scenario in my environment like I am also getting output in postman but facing error in ADF as below:

  • Getting output in postman enter image description here

  • Facing similar error in ADF enter image description here

I believe the error information implies that the source data's non-standard JSON format prevents ADF from deserializing it. JSON that isn't legal cannot be copied using ADF. Because when I tried with another Api with Correct Json format output, I am able to see the preview the data, as below:

enter image description here

The connection documentation states that ADF supports the JIRA connector. Perhaps you could give that a go.

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11