I am new to Square API and am finding it difficult to join order items to corresponding catalog data. Can anyone provide me the foreign key join path between the two data sets? Thanks, Steven

Thank you Bryan, That was the solution. Is there a published ERD for the API Endpoints? Steven

Unfortunately, there isn’t entity relationship diagram for all the objects across our APIs. We do document everything and you’re always more then welcome to ask. :slightly_smiling_face:

Hi Bryan, I am having difficulty completing a report for a customer using the order item and catalog datasets. The customer is using categories in the square reporting tools and I am having difficulty joining the Catalog_Categories to Line Items. Is this something you can help me with? Thanks, …

Happy to help. Are you getting the related_objects for the items in an order which will include the category_id to build the reports? :slightly_smiling_face:

Join Order Item records to Catalog records?

Questions

Bryan-Square March 17, 2023, 6:16pm 2

Welcome! Each order will have a catalog_object_id that you can use the Catalog API to retrieve the item variation details. If there’s no catalog_object_id in the line_items then that item is an ad hoc item.

Topic		Replies	Views
Why Some line items in order API lacks catalog object id? Questions orders-api	2	1260	July 4, 2022
Retrieve category from order item Questions orders-api , payments-api , catalog-api	3	1047	June 6, 2022
Trouble with Items (API) Questions orders-api , catalog-api , oauth-api	1	1356	December 4, 2021
Search Orders response has no usable ID for line_items Questions orders-api , catalog-api	9	1628	August 6, 2020
What is order.line_items.catalog_object_id? Questions orders-api , payments-api , catalog-api	6	588	February 19, 2024

Join Order Item records to Catalog records?

Related topics