Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

POWER BI API ISBN NUMBERS

I'm trying to set up an API (bit of a newbie here with API on Power BI) to go to the ISBN website and retrieve data against a column of ISBN numbers in a table in Power BI.   Is this possible.?  Ea...
Need Help
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

which of the many ISBN search services are you planning to use?  What's the expected frequency of your requests?

 

let
    #"HTML Code" = Web.BrowserContents("https://isbnsearch.org/isbn/9781324003991"),
    #"Imported Text" = Lines.FromText(#"HTML Code"),
    #"Removed Top Items" = List.Skip(#"Imported Text",34),
    #"Kept First Items" = List.FirstN(#"Removed Top Items",7)
in
    #"Kept First Items"