Forum Discussion

daniel_007's avatar
daniel_007
New Member
5 months ago
Solved

API load more than one URL and after refresh show empty

Hi there, I have a lot of issues with an API connection. First, I must connect to the API with an URL type https://api/servicios/v1/publico/nn.json?fecha=02022014&ticket=AAEE, that give me 1000 rows...
Need Help
  • daniel_007's avatar
    daniel_007
    5 months ago

    Hi Anonymous, thank you for your message.

    The issue was not resolved, but I already found the way to fix it.

     

    Thank you again.

    Daniel

lbendlin's avatar
lbendlin
Super User
5 months ago

What is your question?  Which application are you planning to use for communication with that API?

 

Keep in mind that Power BI is not a source data storage solution.

  • daniel_007's avatar
    daniel_007
    New Member
    5 months ago

    Source data storage solution? I never said that.

    And I already made it. I used a function and a query that give me the rows that I need. This part of the code has a problem, when I refresh it again, the table shows empty:

    Detalle =
    if List.Count(Codigos) = 0 then
    DetalleVacio
    else
    let
    // Ejecutar la función para cada código
    Tablas = List.Transform(Codigos, each URLconCodigo(_)),

    // Forzar el código en cada tabla ANTES de combinar
    TablasConCodigo =
    List.Transform(
    List.Positions(Codigos),
    (i) =>
    let
    t = Tablas{i},
    c = Codigos{i},
    tConCodigo = Table.AddColumn(t, "Código Licitación", each c, type text)
    in
    tConCodigo
    ),

    // Combinar todas las tablas
    Combinado = Table.Combine(TablasConCodigo)
    in
    Combinado,

     

    What a shame that my post was not understood.

    Regards,