Search list in API with dynamic parameter

[kasife]

Hi guys, 

I need some help.

I need to fetch a list of customers through an API. This API fetches specific clients, so I don't know how I could fetch the entire list of clients. The query requests the customer's document number. How could I make it dynamic to bring in all the customers? How could I do it?

My function

(
    _documento 
)
=>
let
    Fonte = 
        Json.Document(
            Web.Contents(
                "https://cliente.site.com.br/", //Mantém o host da consulta
                [
                    RelativePath = "api/site/cliente", //Altera o RelativePath conforme deseja 
                    Query = 
                    [
                        
                        documento = Number.ToText(_documento)

                    ],       
                    Headers = 
                    [
                        accept = "application/json",
                        email = _email,
                        token = _token
                    ]
                ]
            )
        )
in
    Fonte

invoked function

let
    Source = fx_cliente(12345678910)
in
    Source

Thanks

[v-zhangti · Accepted solution]

Hi, @kasife 

Please refer to the following links in the hopes of helping you.

Solved: How to create a custom dynamic list for REST API p... - Microsoft Power BI Community

Solved: REST API With Authentication and Dynamic Variables - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

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

[kasife]

@v-zhangti 

Many thanks