Forum Discussion

PedroCSeq's avatar
PedroCSeq
Frequent Visitor
2 years ago

Getting a multilevel JSON from an API not working in Fabric Data Factory

Hello everyone! I'm trying to get a multiple JSON files from an API and having issues with a few of them: when using a normal REST connection it returns an invalid opperation (keeping in mind the sa...
Need Help
pipelines
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PedroCSeq ,

Thanks for using Fabric Community.
I can some methods to the JSON deserialization error you're encountering in Fabric Data Factory.

These steps might help:

1. Validate JSON Format:

  • Manually: Inspect a sample of the response from the API using tools like Postman or a browser.
  • Review Structure: Make sure it adheres to JSON syntax rules. You can use a JSON validator online or in your code.


2. Address Unexpected Characters:

  • Trim Leading/Trailing Characters: Remove any extra whitespace or characters before the first curly brace.
  • Check Data: Ensure the response doesn't contain HTML elements or other non-JSON content.


Hope this is helpful. Please let me know incase of further queries.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello PedroCSeq ,

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.

  • sreedharshan10's avatar
    sreedharshan10
    Regular Visitor
    2 years ago

    I have been facing the same issue too.
    When I use web activity the output seems to be previewed without any issues but when I try to recreate the same in Copy data I get an error that my JSON output is invalid
    I have checked the response in postman and that JSON output seems to be valid
    I Would really like to have some clarity on this