Forum Discussion

conradodatacamp's avatar
conradodatacamp
New Member
2 years ago

Doubt on API request through PowerQuery

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.

Need Help
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!