Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PedroCSeq
Frequent Visitor

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 same exact call works fine on Postman): 


Rest call failed with server error, status code 500 InternalServerError, please check your activity settings and remote server issues.

Request URL: [redacted]'.Response: {"returnCode":3,"returnStatus":"INVALID_API_OPERATION"}
Activity ID
de615923-a51c-47ff-9af2-f0b8240c5776
 
When using a generic http connection with the correct accept statement (application/vnd.mambu.v2+json), it can get to the json but Data Factory doesn't recognize it, throwing this error:

Error occurred when deserializing source JSON file '[redacted]'. Check if the data is in valid JSON object format. Unexpected character encountered while parsing value: <. Path '', line 0, position 0.

I have a notebook that can get to it which I'd like to use only if stricty necessary, because saving jsons with notebooks makes it so I can't name the files saved, only the folders it will be put in and it's somewhat important that the files are named uniformelly. 
Anyone knows a method that would work for using the copy activity to get a multilevel JSONs from an API v2?
6 REPLIES 6
PedroCSeq
Frequent Visitor

I had confirmed that the JSON is valid prior to trying to use copy data, by getting it through notebooks. Also, the link is correct and the only response is in json form, as other calls with simpler json responses to the same main api are working using the same connection.

Hi @PedroCSeq ,

Apologies for the issue you have been facing. I would like to check are you still facing this issue? 

If its a bug, we will definitely would like to know and properly address it.

 

Please go ahead and raise a support ticket to reach our support team: Link 

 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Good morning,

Yes, I'm still getting an error:
Access '[redacted]:search?detailsLevel=FULL' is not allowed on Azure integrate runtime.

This should be a very simple post request on this api 

Hello @PedroCSeq ,

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

v-gchenna-msft
Community Support
Community Support

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.

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.