GraphQL Engine


# Select first 5 employees from 'technology' department 
# and get projects they are working on

{
  department(name: "technology") {    
    employees(first: 5) {
      count
      items {
        name
        projects {
          items {
            title
          }
        }
      }
    }
  }
}


# Get first 5 projects with ‘UI’ or ‘Integrations’ 
# tags and order them by creation date

{
  projectsList(
    filter: {tags: {some: {name: {in: ["UI", "Integrations"]}}}}
    first: 5
    orderBy: [createdAt_DESC]
  ) {
    items {
      title
      tags {
        items {
          name
        }
      }
    }
  }
}


# Create a new project, add two employees to it
# and attach a new ‘PDF’ tag in a single transaction

mutation {
  projectCreate(data: {
    title: "Sales Presentation v3.0"
    members: {
      connect: [
        { id: "cjvy7r28l00j701s4etrbfakq"},
        { id: "cjvy7rdoj00je01s48z3lg56n"}
      ]
    },
    tags: {
      create: {
        name: "PDF"
      }
    }
  }) {
    title
    members {
      items {
        name
      }
    }
    tags {
      items {
        name
      }
    }
  }
}


# Query employee picture and address
# ‘address’ is a Smart Field that has sub-fields

{
  employee(id: "cjvy7mp8e001401pbczhi1ry2") {
    name
    picture {
      downloadUrl
    }
    address {
      country
      zip
    }
  }
}


# Get data from connected Salesforce instance
# Query related tables in a single query

{
  salesforce {
    account(id: "001f400000f1DnZAAU") {
      Name
      Opportunities {
        items {
          Name
        }
      }
    }
  }
}


# Group articles by their author's name, count how many articles belong to each author, and return each groups article IDs while excluding anyarticles that do NOT have an author
# Query related tables in a single query

{
  articlesList(groupBy: {
    query: {
      author: {
        name: {
          as: "authorName"
        }
      },
      id: {
        as: "authorPosts",
        fn: {
          aggregate: COUNT
        }
      },
      _groupIds: {
        as: "postsIds"
      }
    },
    having: {
      alias: "authorName"
      string: {
        is_not_empty: true
      }
    }
  }) {
    groups {
      authorName: String
      authorPosts: Int
      postsIds: GroupIds
    }
  }
}


{
  "data": {
    "department": {
      "employees": {
        "count": 6,
        "items": [
          {
            "name": "Isabel Fisher",
            "projects": {
              "items": [
                {
                  "title": "Dashboard v2.0"
                }
              ]
            }
          },
          {
            "name": "Cristen Adams",
            "projects": {
              "items": [
                {
                  "title": "Data migration"
                },
                {
                  "title": "New Login UI"
                }
              ]
            }
          },
          {
            "name": "Ellie Austin",
            "projects": {
              "items": [
                {
                  "title": "Dashboard v2.0"
                },
                {
                  "title": "Data migration"
                }
              ]
            }
          },
          {
            "name": "Naseem Carney",
            "projects": {
              "items": [
                {
                  "title": "New Login UI"
                }
              ]
            }
          },
          {
            "name": "Kaydan Harrell",
            "projects": {
              "items": []
            }
          }
        ]
      }
    }
  }
}


{
  "data": {
    "projectsList": {
      "items": [
        {
          "title": "Dashboard v2.0",
          "tags": {
            "items": [
              {
                "name": "ReactJS"
              },
              {
                "name": "UI"
              }
            ]
          }
        },
        {
          "title": "Data migration",
          "tags": {
            "items": [
              {
                "name": "Integrations"
              }
            ]
          }
        },
        {
          "title": "New Login UI",
          "tags": {
            "items": [
              {
                "name": "ReactJS"
              },
              {
                "name": "UI"
              }
            ]
          }
        }
      ]
    }
  }
}


{
  "data": {
    "projectCreate": {
      "title": "Sales Presentation v3.0",
      "members": {
        "items": [
          {
            "name": "Bryan Rivas"
          },
          {
            "name": "Gabriela Patterson"
          }
        ]
      },
      "tags": {
        "items": [
          {
            "name": "PDF"
          }
        ]
      }
    }
  }
}


{
  "data": {
    "employee": {
      "name": "Isabel Fisher",
      "picture": {
        "downloadUrl": "https://..."
      },
      "address": {
        "country": "United States",
        "zip": "56301"
      }
    }
  }
}


{
  "data": {
    "salesforce": {
      "account": {
        "Name": "GenePoint",
        "Opportunities": {
          "items": [
            {
              "Name": "GenePoint Standby Generator"
            },
            {
              "Name": "GenePoint Lab Generators"
            },
            {
              "Name": "GenePoint SLA"
            }
          ]
        }
      }
    }
  }
}


{
  "data": {
    "articlesList": {
      "groups": [
        {
          "authorName": "James Huxley",
          "authorPosts": 12,
          "postsIds": [
            "ck37jzw2f001b01l7dhm09gcu",
            "ck37jzw2f001j01l77093d05d",
            "ck37jzw2f001a01l73cnf8ax5",
            "ck37jzw2f001i01l723258t3i",
            "ck37jzw2f001h01l78n2hagxp",
            "ck37jzw2f001g01l71wtk87kp",
            "ck37jzw2f001o01l7hjp5ee4n",
            "ck37jzw2f001f01l787o65uh7",
            "ck37jzw2f001e01l76wbmgnrt",
            "ck37jzw2f001m01l74cz49nb4",
            "ck37jzw2f001l01l7f93be80q",
            "ck37jzw2f001c01l78ga4brgb"
          ]
        },
        {
          "authorName": "Huckelberry Ben",
          "authorPosts": 7,
          "postsIds": [
            "ck37jzw2g002501l73ol60z36",
            "ck37jzw2g002l01l75799d0f4",
            "ck37jzw2g002t01l75ehxgbyt",
            "ck37jzw2h003g01l76rzaayho",
            "ck37jzw2g002c01l79r61banv",
            "ck37jzw2g002q01l77hg3hgz2",
            "ck37jzw2g002801l7ha9w90ov"
          ]
        },
        {
          "authorName": "Stephen Begzz",
          "authorPosts": 10,
          "postsIds": [
            "ck37jzw2o005z01l74727gcjl",
            "ck37jzw2n005201l7d5aidgfv",
            "ck37jzw2n004t01l7erv4fkom",
            "ck37jzw2m003w01l7cafeag37",
            "ck37jzw2p007701l7e0w5949g",
            "ck37jzw2n004y01l714dicfap",
            "ck37jzw2n005u01l7hg1u6yii",
            "ck37jzw2n004p01l78w0qfm2i",
            "ck37jzw2n005d01l78g7kd290",
            "ck37jzw2o006801l7ghhs0gm8"
          ]
        }
      ]
    }
  }
}

GRAPHQL API Engine

The 8base GraphQL Engine

A robust query language designed for front-end developers

Auto-generated

Real-Time

Advanced Capabilities

Auto-Documented

Files and Smart Fields

Filtering, Pagination, Sorting

Filtering, Pagination, Sorting

Mutations

Query Data From Salesforce

Integrated GraphQL Developer Tools

Access your Salesforce.com
instance using GraphQL

What are people saying about 8base?

Develop a Custom CRM using Retool and 8base

Building a Public Chat Room with GraphQL Subscriptions

Using GraphQL Mutations to Manage Model Relationships

How 8base helped BLDR to serve new client types, increase revenue

Setting Up Auth0 OTP Authentication with an 8base Workspace

Creating User Profiles in Webflow - Tutorial Part 2

GRAPHQL API Engine

The 8base GraphQL Engine

A robust query language designed for front-end developers

Auto-generated

Real-Time

Advanced Capabilities

Auto-Documented

Files and Smart Fields

Filtering, Pagination, Sorting

Filtering, Pagination, Sorting

Mutations

Query Data From Salesforce

Integrated GraphQL Developer Tools

Access your Salesforce.cominstance using GraphQL

What are people saying about 8base?

Check out these 8base Academy videos:

Develop a Custom CRM using Retool and 8base

Building a Public Chat Room with GraphQL Subscriptions

Using GraphQL Mutations to Manage Model Relationships

Read more about the 8base GraphQL API Engine:

How 8base helped BLDR to serve new client types, increase revenue

Setting Up Auth0 OTP Authentication with an 8base Workspace

Creating User Profiles in Webflow - Tutorial Part 2

Ready to try 8base?

Status

Status

Access your Salesforce.com
instance using GraphQL