Forum Discussion

musicbydannyd's avatar
musicbydannyd
Advocate IV
6 years ago
Solved

JSON from URL in Table Column?

I have simple 2 column table with an ID and URL. Basic structure of URL parts are: Static start to URL (for example: https://examplesite.com/gethistory?id=) ID (same text as ID column) &format=js...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi musicbydannyd ,

     

    Define a variable and then invoke custom function.

    M code may like this:

    (id as number) as table=>
let
    Source = Table.FromRecords(Json.Document(Web.Contents("https://xxxxxxxx" &Number.ToText(id)&"xxxx"))[subjects])
in
    Source

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi musicbydannyd ,

 

Define a variable and then invoke custom function.

M code may like this:

(id as number) as table=>
let
    Source = Table.FromRecords(Json.Document(Web.Contents("https://xxxxxxxx" &Number.ToText(id)&"xxxx"))[subjects])
in
    Source

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • musicbydannyd's avatar
    musicbydannyd
    Advocate IV
    6 years ago

    V-lianl-msft, I was afraid there might be a custom function involved for this rookie... appreciate the example! 😁

     

    Let me do a little more research and I'll report back with a solution or more help.

     

    Thanks again all!

    DannyD

  • musicbydannyd's avatar
    musicbydannyd
    Advocate IV
    6 years ago

    V-lianl-msft, unfortunately, I had to put this project on hold for a while. During my last attempt, I WAS able to successfully create a formula as you described, however was still getting the "Formula.Firewall" error when invoking. Thanks, Danny

  • SWiethorn's avatar
    SWiethorn
    Regular Visitor
    5 years ago

    Liang,

    Please provide more context/explaination around your solution.
    I'm not understanding your answer.

    -S