Forum Discussion

SantiagoG2310's avatar
SantiagoG2310
Regular Visitor
2 years ago
Solved

Copy activity from REST in CSV format

Hi, I have an API connection to get data in CSV format and when I try to create a Copy Activity in a Data Pipeline I got this error: Error occurred when deserializing source JSON file ''. Check i...
Pipelines
  • v-cboorla-msft's avatar
    v-cboorla-msft
    2 years ago

    Hi SantiagoG2310 

     

    Thanks for using Microsoft Fabric Community.

    Apologies for the issue that you are facing here.

     

    When you encounter an error while deserializing source JSON data, it could be due to various reasons such as invalid JSON format, incorrect data types, or missing fields. To resolve this issue, you can try the following steps:

    • Check if the JSON data is in a valid format. You can use an online JSON validator tool to validate the JSON data.
    • Ensure that the data types of the JSON fields match the expected data types.
    • Verify that all the required fields are present in the JSON data.

    If the issue still persists, you can try changing the connection type from REST to HTTP this might help you.

     

    If you can provide more details about your specific pipeline setup, API connection configuration, sample data, and screenshot of the error message, to understand the query and guide you in a better way.

     

    I hope the information helps. Please do let us know if you have any further questions. Glad to help.

     

    Thanks

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi SantiagoG2310 

 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing here.

 

When you encounter an error while deserializing source JSON data, it could be due to various reasons such as invalid JSON format, incorrect data types, or missing fields. To resolve this issue, you can try the following steps:

  • Check if the JSON data is in a valid format. You can use an online JSON validator tool to validate the JSON data.
  • Ensure that the data types of the JSON fields match the expected data types.
  • Verify that all the required fields are present in the JSON data.

If the issue still persists, you can try changing the connection type from REST to HTTP this might help you.

 

If you can provide more details about your specific pipeline setup, API connection configuration, sample data, and screenshot of the error message, to understand the query and guide you in a better way.

 

I hope the information helps. Please do let us know if you have any further questions. Glad to help.

 

Thanks

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi SantiagoG2310 


    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
    In case if you have any resolution please do share that same with the community as it can be helpful to others.
    Otherwise, will respond back with the more details and we will try to help.


    Thanks

  • SantiagoG2310's avatar
    SantiagoG2310
    Regular Visitor
    2 years ago

    Hi v-cboorla-msft,

    Thanks for your response, I change the connection type to HTTP but I dont have idea how pass a Bearer Token in Header and found that is simple than headerName: headerValue in Aditional Headers field.

     

    Thanks Again.

    Regards.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi SantiagoG2310 

       

      Glad that your query got resolved.

      Please continue using Fabric Community for any help regarding your queries.