Skip to main content
Question

RESTful API to Create Lookup Fields?

  • Jun 18, 2025 9:00 PM UTC
  • 1 reply
  • 85 views

Forum|alt.badge.img

Can a RESTful API be used to create lookup fields using a pipeline? Or, can anyone suggest a faster way to create 130 lookup fields for a use case in which I have 130 relationships between two tables (I need a new lookup field for each relationship)? I'm hoping to find a faster way of doing this other than manually one-by-one.

1 reply

Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 27, 2026 1:17 AM UTC

Yes, just not with the Create a field call. The JSON API's Update a relationship call takes a list of parent field IDs and adds them as lookup fields to that relationship, and it doesn't touch the lookups that are already there.

The relationship ID is the field ID of the reference field on the child table. Get all relationships on the child table will list all 130 of them for you.

Then it's one call per relationship:

POST https://api.quickbase.com/v1/tables/{childTableId}/relationship/{relationshipId}
{"lookupFieldIds": [6]}

Swap 6 for the parent field you want looked up. A short script or a Postman collection runner gets through 130 of these in a minute, and it's easier to rerun than a pipeline if you miss one.

https://developer.quickbase.com/operation/updateRelationship