Forum Discussion

Phoenixke's avatar
Phoenixke
Frequent Visitor
8 years ago
let
    photos = Table.ExpandRecordColumn(
                Table.FromList(
                    Json.Document(Web.Contents("https://api.fulcrumapp.com",
                    [Headers=[#"Accept"="application/json", 
                              #"Content-Type"="application/json", 
                              #"X-ApiToken"="5db3ef309dbec743c34e71b1119fedff394a54473f0203a7894e203914e53f427c33991045777b77"],
                    RelativePath = "/api/v2/photos.json"]))[photos], 
                Splitter.SplitByNothing(), null, null, ExtraValues.Error), 
            "Column1", {"access_key", "created_at", "updated_at", "uploaded", "stored", "processed", "deleted_at", "record_id", "form_id", "file_size", "content_type", "latitude", "longitude", "url"}, {"access_key", "created_at", "updated_at", "uploaded", "stored", "processed", "deleted_at", "record_id", "form_id", "file_size", "content_type", "latitude", "longitude", "url"})
in
    photos

I've slightly 'refactored' your query, the result should be the same.

The linking should be handled via 'Manage Relationships'. There was an update to the renaming (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary-2/#rename) but I don't think you'll be able to use something like a switch statement for renaming the colums.

  • Phoenixke's avatar
    Phoenixke
    Frequent Visitor
    8 years ago

    If the fulcrumapp's API supports it, you should be able to use it.

    In PBI you would simply paste the entire url into a Web request and if the "?q=" part is correct, it should simply pull in the data.

     

    I'd start with something simple like ?q=SELECT * FROM "table_name"