Forum Discussion

Ahmed_Mousa_480's avatar
Ahmed_Mousa_480
Regular Visitor
2 years ago

I Need call all page from API

Pleas Help 

let
// Construct the URL for the specified page
pageUrl = "https://soda.demo.socrata.com/resource/earthquakes.json",

 

// Retrieve data from the specified page
data = Web.Contents(pageUrl),

// Convert the JSON data to a text value
jsonData = Json.Document(data),
#"Converted to Table" = Table.FromList(jsonData, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"source", "earthquake_id", "magnitude", "depth", "region"}, {"Column1.source", "Column1.earthquake_id", "Column1.magnitude", "Column1.depth", "Column1.region"})
in
#"Expanded Column1"

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    They recommend using ODATA instead of the API

     

    Open A Data & Insights Dataset In Microsoft Power BI – Data & Insights Client Center (socrata.com)

     

    let
    Source = OData.Feed("https://soda.demo.socrata.com/api/odata/v4/4tka-6guv", null, [Implementation="2.0"]),
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "location", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"location.1", "longitude", "latitude"}),
    #"Replaced Value" = Table.ReplaceValue(#"Split Column by Delimiter","(","",Replacer.ReplaceText,{"longitude"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",")","",Replacer.ReplaceText,{"latitude"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value1",{{"longitude", type number}, {"latitude", type number}})
in
    #"Changed Type"