Users
user
#
A user is the people side of Raindrop — who's signed in, who they report to, what role they're playing today. Read users to power sign-in flows, org charts, and approval routing. Write to invite teammates and update profiles.
account
String
billing_admin
Boolean!
budgetary_approval
numeric
cart_item_count
Int
A computed field, executes function "rd_user_cart_item_count"
created_at
timestamptz!
created_by
String!
created_by_user
user
An object relationship
department_id
Int
email
String!
external_id
String
first_name
String
id
String!
instance_id
Int!
is_archived
Boolean!
is_cart_admin
Boolean!
is_catalog_admin
Boolean!
is_deleted
Boolean
is_email_bounced
Boolean
is_finance_admin
Boolean!
is_inactive
Boolean!
is_invoice_contact
Boolean!
is_payment_contact
Boolean!
is_primary_contact
Boolean!
is_purchase_order_contact
Boolean!
is_rainsign_admin
Boolean!
last_name
String!
manager
user
An object relationship
manager_email
String
name
String!
nickname
String
phone
String
po_headers
[po_header!]!
An array relationship
po_headers_aggregate
po_header_aggregate!
An aggregate relationship
privilege
jsonb
role
role!
An object relationship
role_id
Int!
scim
jsonb!
scorecards
[scorecard!]!
An array relationship
scorecardsByApproverId
[scorecard!]!
An array relationship
scorecardsByApproverId_aggregate
scorecard_aggregate!
An aggregate relationship
scorecards_aggregate
scorecard_aggregate!
An aggregate relationship
sourcing_event_business_users
[sourcing_event_business_user!]!
An array relationship
sourcing_event_business_users_aggregate
sourcing_event_business_user_aggregate!
An aggregate relationship
sourcing_events
[sourcing_event!]!
An array relationship
sourcing_events_aggregate
sourcing_event_aggregate!
An aggregate relationship
system_access
Boolean!
title
String
updated_at
timestamptz!
updated_by
String!
updated_by_user
user
An object relationship
user_businesses
[user_business!]!
An array relationship
user_businesses_aggregate
user_business_aggregate!
An aggregate relationship
uuid
uuid!
Filter any list query with where: over the same columns — see the Read example below.
Read & query
List users
curl https://${RAINDROP_API_HOST}/gql \
-H "Authorization: Bearer ${RAINDROP_API_KEY}" \
-H "Content-Type: application/json" \
--data-raw '{"query":"query ListUser {\n user(limit: 10) {\n id\n account\n billing_admin\n budgetary_approval\n }\n}"}'
const r = await fetch("https://${RAINDROP_API_HOST}/gql", {
method: "POST",
headers: {
"Authorization": `Bearer ${process.env.RAINDROP_API_KEY}`,
"Content-Type": "application/json",
},
body: JSON.stringify({
query: `query ListUser {
user(limit: 10) {
id
account
billing_admin
budgetary_approval
}
}`,
}),
});
const { data } = await r.json();
import os, requests
r = requests.post(
"https://${RAINDROP_API_HOST}/gql",
headers={"Authorization": f"Bearer {os.environ['RAINDROP_API_KEY']}"},
json={
"query": """query ListUser {
user(limit: 10) {
id
account
billing_admin
budgetary_approval
}
}""",
},
)
data = r.json()["data"]
payload, _ := json.Marshal(map[string]any{
"query": `query ListUser {
user(limit: 10) {
id
account
billing_admin
budgetary_approval
}
}`,
})
req, _ := http.NewRequest("POST", "https://${RAINDROP_API_HOST}/gql", bytes.NewReader(payload))
req.Header.Set("Authorization", "Bearer "+os.Getenv("RAINDROP_API_KEY"))
req.Header.Set("Content-Type", "application/json")
resp, err := http.DefaultClient.Do(req)
Response
{
"data": {
"user": [
{
"account": "example",
"billing_admin": true,
"budgetary_approval": 1,
"id": 1
},
{
"account": "example",
"billing_admin": true,
"budgetary_approval": 1,
"id": 2
}
]
}
}
Get one by id
curl https://${RAINDROP_API_HOST}/gql \
-H "Authorization: Bearer ${RAINDROP_API_KEY}" \
-H "Content-Type: application/json" \
--data-raw '{"query":"query GetUser($id: Int!) {\n user(where: {id: {_eq: $id}}) {\n id\n account\n billing_admin\n budgetary_approval\n }\n}","variables":{"id":1}}'
const r = await fetch("https://${RAINDROP_API_HOST}/gql", {
method: "POST",
headers: {
"Authorization": `Bearer ${process.env.RAINDROP_API_KEY}`,
"Content-Type": "application/json",
},
body: JSON.stringify({
query: `query GetUser($id: Int!) {
user(where: {id: {_eq: $id}}) {
id
account
billing_admin
budgetary_approval
}
}`,
variables: {
"id": 1
},
}),
});
const { data } = await r.json();
import os, requests
r = requests.post(
"https://${RAINDROP_API_HOST}/gql",
headers={"Authorization": f"Bearer {os.environ['RAINDROP_API_KEY']}"},
json={
"query": """query GetUser($id: Int!) {
user(where: {id: {_eq: $id}}) {
id
account
billing_admin
budgetary_approval
}
}""",
"variables": {
"id": 1
},
},
)
data = r.json()["data"]
payload, _ := json.Marshal(map[string]any{
"query": `query GetUser($id: Int!) {
user(where: {id: {_eq: $id}}) {
id
account
billing_admin
budgetary_approval
}
}`,
"variables": {
"id": 1
},
})
req, _ := http.NewRequest("POST", "https://${RAINDROP_API_HOST}/gql", bytes.NewReader(payload))
req.Header.Set("Authorization", "Bearer "+os.Getenv("RAINDROP_API_KEY"))
req.Header.Set("Content-Type", "application/json")
resp, err := http.DefaultClient.Do(req)
Response
{
"data": {
"user": [
{
"account": "example",
"billing_admin": true,
"budgetary_approval": 1,
"id": 1
}
]
}
}
Create
Insert a user
curl https://${RAINDROP_API_HOST}/gql \
-H "Authorization: Bearer ${RAINDROP_API_KEY}" \
-H "Content-Type: application/json" \
--data-raw '{"query":"mutation CreateUser($object: user_insert_input!) {\n insert_user_one(object: $object) {\n id\n account\n billing_admin\n budgetary_approval\n }\n}","variables":{"object":{"account":"example","billing_admin":true,"budgetary_approval":1}}}'
const r = await fetch("https://${RAINDROP_API_HOST}/gql", {
method: "POST",
headers: {
"Authorization": `Bearer ${process.env.RAINDROP_API_KEY}`,
"Content-Type": "application/json",
},
body: JSON.stringify({
query: `mutation CreateUser($object: user_insert_input!) {
insert_user_one(object: $object) {
id
account
billing_admin
budgetary_approval
}
}`,
variables: {
"object": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1
}
},
}),
});
const { data } = await r.json();
import os, requests
r = requests.post(
"https://${RAINDROP_API_HOST}/gql",
headers={"Authorization": f"Bearer {os.environ['RAINDROP_API_KEY']}"},
json={
"query": """mutation CreateUser($object: user_insert_input!) {
insert_user_one(object: $object) {
id
account
billing_admin
budgetary_approval
}
}""",
"variables": {
"object": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1
}
},
},
)
data = r.json()["data"]
payload, _ := json.Marshal(map[string]any{
"query": `mutation CreateUser($object: user_insert_input!) {
insert_user_one(object: $object) {
id
account
billing_admin
budgetary_approval
}
}`,
"variables": {
"object": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1
}
},
})
req, _ := http.NewRequest("POST", "https://${RAINDROP_API_HOST}/gql", bytes.NewReader(payload))
req.Header.Set("Authorization", "Bearer "+os.Getenv("RAINDROP_API_KEY"))
req.Header.Set("Content-Type", "application/json")
resp, err := http.DefaultClient.Do(req)
Response
{
"data": {
"insert_user_one": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1,
"id": 1
}
}
}
Update
Update a user
curl https://${RAINDROP_API_HOST}/gql \
-H "Authorization: Bearer ${RAINDROP_API_KEY}" \
-H "Content-Type: application/json" \
--data-raw '{"query":"mutation UpdateUser($id: Int!, $changes: user_set_input!) {\n update_user(where: {id: {_eq: $id}}, _set: $changes) {\n affected_rows\n returning {\n id\n account\n billing_admin\n budgetary_approval\n }\n }\n}","variables":{"changes":{"account":"example","billing_admin":true,"budgetary_approval":1},"id":1}}'
const r = await fetch("https://${RAINDROP_API_HOST}/gql", {
method: "POST",
headers: {
"Authorization": `Bearer ${process.env.RAINDROP_API_KEY}`,
"Content-Type": "application/json",
},
body: JSON.stringify({
query: `mutation UpdateUser($id: Int!, $changes: user_set_input!) {
update_user(where: {id: {_eq: $id}}, _set: $changes) {
affected_rows
returning {
id
account
billing_admin
budgetary_approval
}
}
}`,
variables: {
"changes": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1
},
"id": 1
},
}),
});
const { data } = await r.json();
import os, requests
r = requests.post(
"https://${RAINDROP_API_HOST}/gql",
headers={"Authorization": f"Bearer {os.environ['RAINDROP_API_KEY']}"},
json={
"query": """mutation UpdateUser($id: Int!, $changes: user_set_input!) {
update_user(where: {id: {_eq: $id}}, _set: $changes) {
affected_rows
returning {
id
account
billing_admin
budgetary_approval
}
}
}""",
"variables": {
"changes": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1
},
"id": 1
},
},
)
data = r.json()["data"]
payload, _ := json.Marshal(map[string]any{
"query": `mutation UpdateUser($id: Int!, $changes: user_set_input!) {
update_user(where: {id: {_eq: $id}}, _set: $changes) {
affected_rows
returning {
id
account
billing_admin
budgetary_approval
}
}
}`,
"variables": {
"changes": {
"account": "example",
"billing_admin": true,
"budgetary_approval": 1
},
"id": 1
},
})
req, _ := http.NewRequest("POST", "https://${RAINDROP_API_HOST}/gql", bytes.NewReader(payload))
req.Header.Set("Authorization", "Bearer "+os.Getenv("RAINDROP_API_KEY"))
req.Header.Set("Content-Type", "application/json")
resp, err := http.DefaultClient.Do(req)
Response
{
"data": {
"update_user": {
"affected_rows": 1,
"returning": [
{
"account": "example",
"billing_admin": true,
"budgetary_approval": 1,
"id": 1
}
]
}
}
}