Forum Discussion

webportal's avatar
webportal
Impactful Individual
3 years ago

Dataflow to get data from REST API

Hello,   I'm trying to get the data from an API with: Json.Document(Web.Contents("https://dominio.com/api/index.php/v1/GetData", [Headers=[Authorization="Bearer xxxx", Accept="*/*"]])) The data...
Need Help
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

webportal Please Can you elaborate on which data source are using for data load in Power bi. Thank You!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks, I tried this and it worked:

    = Json.Document(Web.Contents("https://www.dominio.com/api/GetData", [Headers=[Authorization="Bearer xxx", Accept="*/*", Content="application/json"]]))

    But now I have another situation.

    Of the 3 tables I have in Joomla, which I'm fetching via API, one of them worked (according to the image above) and another 2 with different errors:

    1) One of them says that the format is invalid

    2) And the other one says it gives me error 404:

    Any tips on how to resolve this?