Bendystraw

Bendystraw is a GraphQL API for the Juicebox protocol built using Ponder, an open-source framework for indexing on-chain events, and maintained by Peri.

Ponder indexes events emitted by the protocol, and stores data in two databases with identical schemas—one for mainnets, and one for testnets. Each has its own URL, and a playground where you can browse the schema and make queries against real data.

Base URL	bendystraw.xyz	testnet.bendystraw.xyz
Chains	Ethereum Arbitrum Base Optimism	Sepolia Arbitrum Sepolia Base Sepolia Optimism Sepolia
Status
	Playground	Playground

---

Getting Started

Authentication

To make queries, first contact Peri for an API key. API keys should not be exposed. If you need to make requests from a frontend, consider using a server side proxy.

Schema

To download the schema (e.g. for generating graphql types in your frontend):

GET https://bendystraw.xyz/schema (no API key)

Schemas are the same for both mainnet and testnet databases.

GraphQL Queries

POST https://<url>/<api-key>/graphql

Singular queries

• Return a single row from a table. Must define primary key for table (e.g. for projects, primary key is compound projectId + chainId). Response contains only the row data.

  GraphQL	Response
  project(projectId, chainId) { balance volume suckerGroupId ... }	{ project: { balance, volume, suckerGroup, ... } }

Plural queries

• Return multiple rows from a table. Must define at least one of: where, limit, orderBy, orderDirection. Also supports pageInfo and totalCount (see Ponder docs for details).

  GraphQL	Response
  projects( where: { chainId: 1 }, orderBy: "createdAt", orderDirection: "desc", limit: 10 ) { items { balance volume suckerGroupId ... } pageInfo { endCursor hasNextPage ... } totalCount }	{ projects: { totalCount, pageInfo: { endCursor, hasNextPage, ... }, items: { balance, volume, suckerGroupId, ... }[] } }

Special Queries

Some data is not conveniently accessible via GraphQL, but may be requested via other endpoints.

• /participants Participants snapshot at timestamp

  Retrieve every participantSnapshot object for a sucker group, at a particular timestamp, de-duped by wallet address. Useful for checking all wallets' token balances at a particular point in time.

  Note: Retrieving participants for a particular block height is impractical here, as block numbers are not consistent across chains.

  GraphQL	Response
  POST https://<url>/<api-key>/participants // body { suckerGroupId: "", timestamp: 42069, // unix timestamp (seconds) }	{ chainId, projectId, suckerGroupId, timestamp, block, address, volume, volumeUsd, balance, creditBalance, erc20Balance, }[]

---

Guides & Patterns

ChainId

Because Bendystraw indexes data from multiple chains, nearly every table includes a chainId property. This is useful for filtering data by chain, or simply differentiating which chain a table row was created from. Nearly every compound primary key also makes use of chainId.

Sucker Groups

A sucker group is a group of linked projects on different chains. These projects act as a single omnichain project, with shared revenue and tokens. While the projects table has a compound primary key of projectId + chainId, the suckerGroups table uses a single id primary key.

Most tables (participants, activityEvents, etc) include a suckerGroupId column, which can be used to filter rows in a graphQL response.

projectIds of projects within a sucker group are not guaranteed to be consistent across chains, so filtering by projectId is only recommended when also filtering by chainId.

Unique IDs

Always obtain unique IDs (e.g. suckerGroup.id) in real time. Unique IDs may change anytime Bendystraw is updated, and should not be relied on to remain consistent.

---

Links

• Github
• Legal