Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
RobertMichels10
Frequent Visitor

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

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
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   

 

2 REPLIES 2
v-cgao-msft
Community Support
Community Support

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

vcgaomsft_0-1701242455740.png

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

It worked, but I get as result this

RobertMichels10_0-1701259561134.png

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

R.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors