CatalogInfo
Returns information about the catalog API, including API limits and the current API version.
Table Specific Information
Select
The driver will execute all filters to this view client-side, in memory.Returns a single row describing the operational limits for the Square Catalog API, along with the language code and a list of supported standard measurement units.
SELECT * FROM CatalogInfo
Retrieve only the API limit values:
SELECT BatchUpsertMaxObjectsPerBatch, BatchRetrieveMaxObjectIds, BatchDeleteMaxObjectIds FROM CatalogInfo
Retrieve the language code and standard unit descriptions:
SELECT LanguageCode, StandardUnitDescriptions FROM CatalogInfo
Columns
| Name | Type | Description |
| BatchUpsertMaxObjectsPerBatch | Integer | The maximum number of objects that may appear within a single batch in a BatchUpsertCatalogObjects request. |
| BatchUpsertMaxTotalObjects | Integer | The maximum number of objects across all batches for a single BatchUpsertCatalogObjects request. |
| BatchRetrieveMaxObjectIds | Integer | The maximum number of object IDs that may appear in a BatchRetrieveCatalogObjects request. |
| SearchMaxPageLimit | Integer | The maximum number of results per page that may be returned for a SearchCatalogObjects request. |
| BatchDeleteMaxObjectIds | Integer | The maximum number of object IDs that may appear in a BatchDeleteCatalogObjects request. |
| UpdateItemTaxesMaxItemIds | Integer | The maximum number of item IDs that may appear in an UpdateItemTaxes request. |
| UpdateItemTaxesMaxTaxesToEnable | Integer | The maximum number of tax IDs to be enabled that may appear in an UpdateItemTaxes request. |
| UpdateItemTaxesMaxTaxesToDisable | Integer | The maximum number of tax IDs to be disabled that may appear in an UpdateItemTaxes request. |
| UpdateItemModifierListsMaxItemIds | Integer | The maximum number of item IDs that may appear in an UpdateItemModifierLists request. |
| UpdateItemModifierListsMaxModifierListsToEnable | Integer | The maximum number of modifier list IDs to be enabled that may appear in an UpdateItemModifierLists request. |
| UpdateItemModifierListsMaxModifierListsToDisable | Integer | The maximum number of modifier list IDs to be disabled that may appear in an UpdateItemModifierLists request. |
| LanguageCode | String | The language used for the standard unit descriptions, in BCP 47 format (for example, en-US). |
| StandardUnitDescriptions | String | A list of standard measurement units, each including a name, abbreviation, and unit type. |