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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Get data from Firebase realtime database

Trying to retrieve data from a firebase realtime datasabe, i am using a blank query with the instruccion:

 

Sin título.png

 

Any idea to get the data?

 

Thanks in advanced!

 

 
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @v-easonf-msft 

 

I was able to solve it by adding a document name with ".json" at the end.

 

let
Origen = Json.Document(Web.Contents("https://xxxxxxx.com/contacts.json"))
in
Origen

 

I checked that the syntaxiss was correct with the URL you provided me but was not able to enclose the json body in brackets dinamically. I tried using Text.Combine M function to the returned object but was not able to add to an binary object.

 

Thanks u anyway! 🙂

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

As mentioned by the error message: 

Additional characters were found at the end of the JSON entry.

This error is usually caused by your incorrect json format. (Here is a similar related thread)

 

It is suggest  to enclose the json body in brackets after you have checked that your json syntax is correct (JSON Formatter & Validator beautifies and debugs JSON data with advanced formatting and validation algorithms.) .

Sample like this:

[
   {
      "timestamp":"2019-05-11T22:39:13.908347",
      "current_ma":22,
      "voltage_mv":229979,
      "energy_wh":15,
      "power_mw":0
   }, {
      "timestamp":"2019-05-11T22:39:33.810613",
      "current_ma":21,
      "voltage_mv":230081,
      "energy_wh":15,
      "power_mw":0
   }
]

 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Hi @v-easonf-msft 

 

I was able to solve it by adding a document name with ".json" at the end.

 

let
Origen = Json.Document(Web.Contents("https://xxxxxxx.com/contacts.json"))
in
Origen

 

I checked that the syntaxiss was correct with the URL you provided me but was not able to enclose the json body in brackets dinamically. I tried using Text.Combine M function to the returned object but was not able to add to an binary object.

 

Thanks u anyway! 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.