trying to run a Graphql query in powerBi/power query - Expression.SyntaxError

[RobertMichels10]

I m trying to run a graphql query in power BI / power query, but I get 'Expression.SyntaxError' as result.
Can you help me, please? this is the query

let

url = "https://api.hostfully.com/api/v3/graphql",

client_id = "xxxxxxxx",

client_secret = "xxxxxxxx",

    Source = Web.Contents(

url,

[

Headers=[

#"Method"="GET",

#"Content-Type"="application/json",

#"client_id"=client_id,

            #"client_secret"=client_secret

],

Content=Text.ToBinary("{""query"": ""{

    Leads {

    leads(propertyUid: null, agencyUid: 'xxxxxx') {

        guestInformation {

            firstName

            lastName

            flightNumber

            reasonForTrip

            adultCount

            childrenCount

            petCount

            infantCount

        }

        order {

            id

            creationDateTimeString

            currency

            currencySymbol

            totalAmount

            transactions {

                date

                type

                amount

                status

            }

        }

    }

    lead(uid: 'xxxxxxxx') {

        status

        type

        source

        bookedUtcDateTime

        notes

        extraNotes

        checkInLocalDateTime

        checkOutLocalDateTime

    }

}

"JSON"= Json.Document(Source)

in

    JSON   

[Anonymous]

Hi @RobertMichels10 ，

Please try this:

let
  url = "https://api.hostfully.com/api/v3/graphql", 
  client_id = "xxxxxxxx", 
  client_secret = "xxxxxxxx", 
  query
    = "{""query"": ""{
        Leads {
            leads(propertyUid: null, agencyUid: 'xxxxxx') {
                guestInformation {
                    firstName
                    lastName
                    flightNumber
                    reasonForTrip
                    adultCount
                    childrenCount
                    petCount
                    infantCount
                }
                order {
                    id
                    creationDateTimeString
                    currency
                    currencySymbol
                    totalAmount
                    transactions {
                        date
                        type
                        amount
                        status
                    }
                }
            }
            lead(uid: 'xxxxxxxx') {
                status
                type
                source
                bookedUtcDateTime
                notes
                extraNotes
                checkInLocalDateTime
                checkOutLocalDateTime
            }
        }
    }""", 
  Source = Web.Contents(
    url, 
    [
      Headers = [
        #"Method"       = "POST", 
        #"Content-Type" = "application/json", 
        #"x-api-key"    = client_secret
      ], 
      Content = Text.ToBinary(query)
    ]
  ), 
  JSON = Json.Document(Source)
in
  JSON

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[RobertMichels10]

It worked, but I get as result this

I get no data. Do you know what is going on?
thanks in advance!

R.