Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Take data from api with automatique loop

Hi !  I want to take data from API with an automatique id loop.   I'm not really good in Json but i created this code. I'm stuck on the last lines of development.   The code ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I don't need this list union 😮
    I just missed to add this line on the GetUrl

     

    Json = GetJson(Url),

     

    Thank you for yours help 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

try replacing thjis

 

    URLs  = List.Transform(PageIndices, each GetUrl(_)),

    Entities    = List.Union(URLs)
in
    Entities

 

 

with this one

 

    URLs  = List.Transform(PageIndices, each GetUrl(_))

in
   URLs

 

 

 

PS

be careful not to leave the comma before in

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    When I do what you say I just have my address list that I want to request which it doesn't do.

    Best regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      my suggestion was related to the error you reported. I have not read and understood the meaning and purpose of your code to give a complete answer (I don't have time to do such a thing).
      I only saw that you improperly used the list.union function and suggested that you exclude it to get a correct but incomplete result.
      <<can't convert the value "https://ecofac.nicoka..." in type list.>>

      I'm sorry if the suggestion is not enough to completely solve your problem.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Yeah, I think I have to use a list.union to request my whole list to get all the data.
        But this line doesn't actually work.