Fixing Zapier webhook for Upsert Catalog Object endpoint

Questions
4

Hey Bryan,

Thanks for coming back to me. I’m getting closer, but not fixed.

This is the body now:

{
"idempotency_key": "{{240283442__id}}{{zap_meta_timestamp}}",
  "batches": [
{  "objects": [
{
    "type": "ITEM",
    "id": "#{{240283442__id}}",
    "updated_at": "{{zap_meta_timestamp}}",
    "created_at": "{{zap_meta_timestamp}}",
    "present_at_all_locations": false,
    "present_at_location_ids": [
      "LJCAQQ7GEX7JZ"
    ],
    "item_data": {
      "name": "{{240283442__Name}}",
      "is_taxable": true,
      "variations": [
        {
          "type": "ITEM_VARIATION",
          "id": "#NEW{{240283442__id}}",
          "is_deleted": false,
          "present_at_all_locations": false,
          "present_at_location_ids": [
            "LJCAQQ7GEX7JZ"
          ],
          "item_variation_data": {
            "item_id": "#{{240283442__id}}",
            "name": "{{240283442__Name}}",
            "sku": "{{240283442__EAN for Automation}}",
            "upc": "{{240283442__EAN for Automation}}",
            "ordinal": 1,
            "pricing_type": "FIXED_PRICING",
            "price_money": {
              "amount": {{240283442__Price for Square API}},
              "currency": "GBP"
            },
            "location_overrides": [
              {
                "location_id": "LJCAQQ7GEX7JZ",
                "track_inventory": true
              }
            ],
            "track_inventory": true,
            "sellable": true,
            "stockable": true,
            "default_unit_cost": {
              "amount": {{240283442__Cost Price for Square API}},
              "currency": "GBP"
            },
                "item_variation_vendor_info_data": {
                  "ordinal": 1,
                  "sku": "{{240283442__Brand ID}}",
                  "price_money": {
                    "amount": {{240283442__Price for Square API}},
                    "currency": "GBP"
                  },
                  "item_variation_id": "#NEW{{240283442__id}}",
                  "vendor_id": "{{240283442__Brand ID}}"
                }
              }
          }
      ],
      "product_type": "REGULAR",
      "skip_modifier_screen": false,
      "ecom_available": false,
      "ecom_visibility": "UNINDEXED",
      "categories": [
        {
          "id": "{{240283442__Square Category ID (from Categories)}}",
          "ordinal": {{240283442__Square Ordinal Depth (from Categories)}}
        }
      ],
      "reporting_category": {
        "id": "{{240283442__Square Category ID (from Categories)}}",
        "ordinal": {{240283442__Square Ordinal Depth (from Categories)}}
      }
    }
  }]
}]}

and I’m getting this response message, although I can’t tell what object it is referring to?

Invalid object: Invalid Object with Id: BTDVIKPPML6ICTCJYY53PM2P [merchant_token=MLMJJ711P7Y63] duplicate int value 1 with string value 5V6I5LHTPIAK4Z65JQIMTQKU found for attribute SQ_ADDITIONAL_CATEGORY (obj ObjectWithAttributes{ Id:51538435,Token:“BTDVIKPPML6ICTCJYY53PM2P”,MasterCatalogId:999567,Type:1(ITEM),CreatedBy:127298844,Timestamp:1714203468467(2024-04-27 07:37:48.467 +0000 UTC) Ordinal:0 Attributes:{ Attribute{Id:532556240,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:113,DefinitionToken:“SQ_3”,StringValue:“One more item”,CreatedBy:127298844} Attribute{Id:532556241,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:120,DefinitionToken:“SQ_ADDITIONAL_CATEGORY”,IntValue:1,StringValue:“5V6I5LHTPIAK4Z65JQIMTQKU”,CreatedBy:127298844} Attribute{Id:532556242,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:56,DefinitionToken:“SQ_COGS_E”,IntValue:1,CreatedBy:127298844} Attribute{Id:532556243,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:153,DefinitionToken:“SQ_10”,IntValue:0,CreatedBy:127298844} Attribute{Id:532556244,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:87,DefinitionToken:“SQ_ITAX”,IntValue:1,CreatedBy:127298844} Attribute{Id:532556245,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:4291255,DefinitionToken:“SQ_IS_ARCHIVED”,IntValue:0,CreatedBy:127298844} Attribute{Id:532556440,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:51,DefinitionToken:“SQ_ECOM_AVAIL”,IntValue:0,CreatedBy:127298907} Attribute{Id:532556441,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:53,DefinitionToken:“SQ_ECOM_VISIBILITY”,IntValue:1,CreatedBy:127298907} Attribute{Id:532556442,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:4677354,DefinitionToken:“SQ_REQUIRES_SUBSCRIPTION_TO_SELL”,IntValue:0,CreatedBy:127298907} Attribute{Id:532557224,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:210,DefinitionToken:“SQ_VIS”,IntValue:1,CreatedBy:127299148} Attribute{Id:532557226,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:3096504,DefinitionToken:“SQ_FPSI”,StringValue:“fprefs_127zdfwvpdfrilm32ppxehbwb”,CreatedBy:127299148} Attribute{Id:532557227,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:246,DefinitionToken:“SQ_FPPI”,StringValue:“fprefs_127zdfwvowpudeu9dhbadhny3”,CreatedBy:127299148} Attribute{Id:532557228,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:245,DefinitionToken:“SQ_FPDI”,StringValue:“fprefs_127zdfwvnu9dmy66um0oxn4or”,CreatedBy:127299148} Attribute{Id:532557229,MasterCatalogId:999567,ObjectId:51538435,ObjectType:1(ITEM),DefinitionId:3096505,DefinitionToken:“SQ_FPDII”,StringValue:“fprefs_127zdfwvodgyra2646gxrahyz”,CreatedBy:127299148} } }) (existing object token ZWMEROJQWN7DZ7QSXWBIENMK). (HTTP Status Code: 400)