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

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