Doubt on API request through PowerQuery

[conradodatacamp]

Hi everyone,

I'm currently attempting to construct a request through an API URL that requires two query parameters: token and $select.

I've tried two different methods to build the request. The first one, which works fine, involves a simple web link request:

let
    Fonte = Json.Document(Web.Contents("https://api.movidesk.com/public/v1/tickets?token=[classified token]&$select=id,type,serviceFull,category,urgency,status,createdDate,origin"))
in
    Fonte

However, this method doesn't allow me to manage pagination. To resolve this issue, I've created the following code:

let
    Fonte = Json.Document(Web.Contents("https://api.movidesk.com/public/v1",
        [
            RelativePath = "/tickets",
            Query = [
                token = "[classified token]",
                select = "id,type,serviceFull,category,urgency,status,createdDate"
            ]
        ]
    ))
in
    Fonte

Unfortunately, using this approach results in a Bad Request (400) error code. Upon investigation, it appears that the $ icon before the select parameter is missing. I've been unable to find the proper method to include the $ before select.

[Anonymous]

Hi @conradodatacamp 

Not sure if this would work but you may have a try.

#"$select" = "id,type,serviceFull,category,urgency,status,createdDate"

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!