Dta Factory Error Json file - RestAPI

Luiz Santos, Stênia 1 Reputation point
2022-11-30T16:33:12.997+00:00

Error occurred when deserializing source JSON file ''. Check if the data is in valid JSON object format.
Unexpected character encountered while parsing value: <. Path '', line 0, position 0.
Activity ID: 8f4c647d-c7dc-4122-bc79-82f8b33e4dd5
265780-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,520 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,021 Reputation points
    2022-12-01T23:39:35.807+00:00

    Hello and welcome to Microsoft Q&A @SteniaSantos-8876

    If I understand correctly, you have a Copy activity using REST dataset as source. It targets open-api.mobiauto.com.br/api/dealer/v1.0/dealers .
    When you run the pipeline, it errors with invalid json.

    The REST dataset expects JSON format to be returned. JSON starts with { or [ . The returned value started with < . HTML and XML start with < . I suspect the result was an HTML page instead of raw JSON data.

    When I try visiting that page, I was redirected to a login page because I did not have any account. If you forgot to authenticate or put wrong password, then the Copy activity might be redirected to error page or login page. These pages are in HTML format, and so start with <.

    In the Copy activity, can you try Preview data / Visualizar dados ?
    Please also check authentication / credentials / login information.

    0 comments