Get data Partner Dashboard

[ameyacharya]

I am trying to get data from my partner dashboard such as: Install count, revenue, etc.

I am not able to figure out the correct query to do that same:

Here's what I have figured out till now:

POST URL: https://partners.shopify.com/[organization_id]/api/2023-07/graphql.json

Header i did correct.

I just need help in "Data" part to send within my request

[Liam]

Hi Ameyacharya,

To fetch app install count, revenue, and other related data, you need to use specific queries in your request data. Below is an example of how you might construct your query:

query {
  partner {
    organization(id: "[organization_id]") {
      apps {
        edges {
          node {
            title
            installationsCount
            appCharges {
              edges {
                node {
                  price {
                    amount
                    currencyCode
                  }
                  status
                }
              }
            }
          }
        }
      }
    }
  }
}

In the above example, you'd replace `[organization_id]` with your actual organization ID.

This query fetches the title of each app, the count of installations, the charges for each app including the price amount and currency, and the status of the charge.

Please note that the API might not support all the fields directly, so if a field is not supported, you would need to remove it from the query.

In your POST request, this query would be included in the body something like this:

{
  "query": "your_query_here"
}

Again, replace `your_query_here` with the actual query. Try to apply this to your use-case as the exact fields and structure might differ based on the API version you're using and the specific data you have access to.

Hope this helps!

[ameyacharya]

Can you please check again? 

When I am trying to run the same code it says "Partner" is not in Queryroot.

[ShopifyDevSup]

Hi @ameyacharya 👋

To query installations and charges on an app, `app.events` can be filtered by the event types:

{
    app (id:"gid://partners/App/123") {
        installs: events(first: 10, types:RELATIONSHIP_INSTALLED) {
            edges {
                node {
                    type
                    occurredAt
                    shop {id}
                }
            }
        }
        charges: events(first: 10, types:[ONE_TIME_CHARGE_ACCEPTED, SUBSCRIPTION_CHARGE_ACCEPTED, USAGE_CHARGE_APPLIED]) {
            edges {
                node {
                    type
                    occurredAt
                    shop {id}
                }
            }
        }
    }
}

Hope that helps!

[ameyacharya]

With this query, I can get the install count and uninstalled count. The difference between them will give me the Active users.

My doubt is, instead of getting the first 20 or 100 installs I want all of them. If not possible maybe I can get all installs for a particular time period.

[ShopifyDevSup]

Hey @ameyacharya - you should be able to pull all of your install events using pagination. Here's an example query:

{
   app (id:"gid://partners/App/app-id-here") {
       installs: events(first: 10, types:RELATIONSHIP_INSTALLED) {
           edges {
               cursor
               node {
                   type
                   occurredAt
                   shop {id}
               }
           }
           pageInfo {
               hasNextPage
           }
       }
       charges: events(first: 10, types:[ONE_TIME_CHARGE_ACCEPTED, SUBSCRIPTION_CHARGE_ACCEPTED, USAGE_CHARGE_APPLIED]) {
           edges {
               cursor
               node {
                   type
                   occurredAt
                   shop {id}
               }
           }
           pageInfo {
               hasNextPage
           }
       }
   }
}

In the response, you'll receive a cursor for each edge, and a hasNextPage boolean (true/false) in pageInfo, letting you know if there are more entries that fit your query criteria. You can then put the cursor output you received into a sequential query like this:

{
   app (id:"gid://partners/App/app-id") {
       installs: events(first: 10, after: "cursor-value-here", types:RELATIONSHIP_INSTALLED) {
           edges {
               cursor
               node {
                   type
                   occurredAt
                   shop {id}
               }
           }
           pageInfo {
               hasNextPage
           }
       }
       charges: events(first: 10, after: "cursor-value-here", types:[ONE_TIME_CHARGE_ACCEPTED, SUBSCRIPTION_CHARGE_ACCEPTED, USAGE_CHARGE_APPLIED]) {
           edges {
               cursor
               node {
                   type
                   occurredAt
                   shop {id}
               }
           }
           pageInfo {
               hasNextPage
           }
       }
   }
}

There's a good reference document here on paginating within our GraphQL APIs that might help if you had any further questions. Hope this helps!

Al | Shopify Developer Support

 

[ShopifyDevSup]

[removed duplicate post - error occurred]