Squarespace Integration Add-On for Dynamics 365

API Integration with Business Central

The Squarespace Integration Addon enables seamless connectivity between your Squarespace store and Microsoft Dynamics 365 Business Central (BC) through secure and robust RESTful APIs. By leveraging classified API requests such as GET, POST, and DELETE, the addon ensures real-time synchronization of store data, products, inventory, and orders, while maintaining complete data integrity and operational efficiency.

Supported API Requests and Functionalities

1. GET Requests:
   Used to retrieve and fetch data from Squarespace, enabling Business Central to stay updated with the latest store information. Common GET operations include:

• Fetch Products: Retrieve the complete product catalog from Squarespace using the API below;
• GET : https://api.squarespace.com/1.0/commerce/products
• {
      “products”: [
          {
              “id”: “691721051d55bf566b73de5c”,
              “type”: “PHYSICAL”,
              “storePageId”: “69172030f85f602fe9ba9b2b”,
              “name”: “testing”,
              “description”: “<p style=\”white-space:pre-wrap;\” data-rte-preserve-empty=\”true\”>testing the product </p>”,
              “url”: “https://prism-parakeet-394l.squarespace.com/store/p/testing”,
              “urlSlug”: “p/testing”,
              “images”: [
                  {
                      “id”: “69172138b0c4a7226c599192”,
                      “altText”: “download.jfif”,
                      “orderIndex”: 0,
                      “url”: “https://images.squarespace-cdn.com/content/v1/691720098047810ad75df011/c18d8060-117b-4395-89fb-97b9aa6e8112/download.jfif”,
                      “originalSize”: {
                          “width”: 253,
                          “height”: 148
                      },
                      “availableFormats”: [
                          “100w”
                      ]
                  }
              ],
              “tags”: [],
              “isVisible”: true,
              “variantAttributes”: [],
              “variants”: [
                  {
                      “id”: “39c57065-0e9a-447e-8f44-b732cd8f6b13”,
                      “sku”: “SQ1289179”,
                      “pricing”: {
                          “basePrice”: {
                              “currency”: “USD”,
                              “value”: “0.00”
                          },
                          “salePrice”: {
                              “currency”: “USD”,
                              “value”: “0.00”
                          },
                          “onSale”: true
                      },
                      “stock”: {
                          “quantity”: 12,
                          “unlimited”: false
                      },
                      “attributes”: {},
                      “shippingMeasurements”: {
                          “weight”: {
                              “unit”: “POUND”,
                              “value”: 1.0
                          },
                          “dimensions”: {
                              “unit”: “INCH”,
                              “length”: 2.0,
                              “width”: 3.0,
                              “height”: 1.0
                          }
                      },
                      “image”: null
                  }
              ],
              “seoOptions”: null,
              “createdOn”: “2025-11-14T12:31:01.332Z”,
              “modifiedOn”: “2025-11-14T12:31:55.242Z”,
              “pricing”: null,
              “digitalGood”: null
          },
          {
              “id”: “69172034dc1bc40ece2581e3”,
              “type”: “PHYSICAL”,
              “storePageId”: “69172030f85f602fe9ba9b2b”,
              “name”: “”,
              “description”: “”,
              “url”: “https://prism-parakeet-394l.squarespace.com/store/p/aax9y6kkx0drpw7nb2uolsjgkf22jx”,
              “urlSlug”: “p/aax9y6kkx0drpw7nb2uolsjgkf22jx”,
              “images”: [],
              “tags”: [],
              “isVisible”: false,
              “variantAttributes”: [],
              “variants”: [
                  {
                      “id”: “18e57751-c5b7-4db8-bcbe-1b4157001f67”,
                      “sku”: “SQ1778675”,
                      “pricing”: {
                          “basePrice”: {
                              “currency”: “USD”,
                              “value”: “0.00”
                          },
                          “salePrice”: {
                              “currency”: “USD”,
                              “value”: “0.00”
                          },
                          “onSale”: false
                      },
                      “stock”: {
                          “quantity”: 0,
                          “unlimited”: true
                      },
                      “attributes”: {},
                      “shippingMeasurements”: {
                          “weight”: {
                              “unit”: “POUND”,
                              “value”: 0.0
                          },
                          “dimensions”: {
                              “unit”: “INCH”,
                              “length”: 0.0,
                              “width”: 0.0,
                              “height”: 0.0
                          }
                      },
                      “image”: null
                  }
              ],
              “seoOptions”: null,
              “createdOn”: “2025-11-14T12:27:32.049Z”,
              “modifiedOn”: “2025-11-14T12:27:32.418Z”,
              “pricing”: null,
              “digitalGood”: null
          }
      ],
      “pagination”: {
          “nextPageUrl”: null,
          “nextPageCursor”: null,
          “hasNextPage”: false
      }
  }

• A request is made to the Squarespace Commerce API to retrieve product information from a given site.

• If properly authenticated and authorized, the API returns a JSON response containing details of all products (or a subset depending on request parameters) — e.g., product titles, IDs, prices, inventory, images, etc.

• If something goes wrong (authentication failure, permissions, rate-limit, site mis-configuration), an error response is returned instead

• Fetch Inventory: Get up-to-date inventory levels to prevent overselling using the API as;
• GET : https://api.squarespace.com/1.0/commerce/inventory/
•             {
      “inventory”: [
          {
              “variantId”: “18e57751-c5b7-4db8-bcbe-1b4157001f67”,
              “sku”: “SQ1778675”,
              “descriptor”: “”,
              “quantity”: 0,
              “isUnlimited”: true
          },
          {
              “variantId”: “39c57065-0e9a-447e-8f44-b732cd8f6b13”,
              “sku”: “SQ1289179”,
              “descriptor”: “testing”,
              “quantity”: 12,
              “isUnlimited”: false
          }
      ],
      “pagination”: {
          “nextPageUrl”: null,
          “nextPageCursor”: null,
          “hasNextPage”: false
      }
  }
• Fetch Store Pages: Access store pages for verification and configuration.
• GET : https://api.squarespace.com/1.0/commerce/inventory/
• {
  “storePages”: [
  {
  “id”: “5f05f78ae1f12f343bd07577”,
  “title”: “Homemade Marinades”,
  “isEnabled”: true
  },
  {
  “id”: “5f05f78ae1f12f343bd07578”,
  “title”: “Consulting Packages”,
  “isEnabled”: true
  }
  ],
  “pagination”: {
  “hasNextPage”: true,
  “nextPageCursor”: “b342f5367c664d3c99aa56f44f95ab0a”,
  “nextPageUrl”: “https://api.squarespace.com/v2/commerce/store_pages?cursor=NTA”
  }
  }
• Fetch Orders: Synchronize new and existing customer orders directly into BC.
• GET : https://api.squarespace.com/1.0/commerce/inventory/

• {
    “result”: [
      {
        “id”: “585d498fdee9f31a60284a37”,
        “orderNumber”: “3”,
        “createdOn”: “2016-12-23T15:58:07.187Z”,
        “modifiedOn”: “2016-12-23T15:58:07.187Z”,
        “channel”: “web”,
        “testmode”: true,
        “customerEmail”: “foo@example.com”,
        “billingAddress”: {
          “firstName”: “Bob”,
          “lastName”: “Loblaw”,
          “address1”: “459 Broadway”,
          “address2”: null,
          “city”: “New York”,
          “state”: “NY”,
          “countryCode”: “US”,
          “postalCode”: “10003”,
          “phone”: “5553334444”
        },
        “shippingAddress”: {
          “firstName”: “Bob”,
          “lastName”: “Loblaw”,
          “address1”: “459 Broadway”,
          “address2”: null,
          “city”: “New York”,
          “state”: “NY”,
          “countryCode”: “US”,
          “postalCode”: “10003”,
          “phone”: “5553334444”
        },
        “fulfillmentStatus”: “PENDING”,
        “lineItems”: [
          {
            “id”: “585d4975dee9f31a60284a16”,
            “variantId”: “88c16ee4-547b-445e-a392-bded9991ae30”,
            “sku”: “SQ3381024”,
            “productId”: “657897afb5f2423e5610e050”,
            “productName”: “Francli Daypack DIY Pattern”,
            “quantity”: 1,
            “unitPricePaid”: {
              “value”: 16.00,
              “currency”: “GBP”
            },
            “lineItemType”: “PHYSICAL_PRODUCT”,
            “imageUrl”: “https://images.squarespace-cdn.com/…/1702402755066-HW6EJ7CBQLUHQYBN3SIP/101223_AG_FRANCLI_DEC23_117.jpg?format=300w”
          }
        ],
        “shippingLines”: [
          {
            “method”: “United Kingdom”,
            “amount”: {
              “value”: 3.00,
              “currency”: “GBP”
            }
          }
        ],
        “subtotal”: {
          “value”: 16.00,
          “currency”: “GBP”
        },
        “shippingTotal”: {
          “value”: 3.00,
          “currency”: “GBP”
        },
        “discountTotal”: {
          “value”: 0.00,
          “currency”: “GBP”
        },
        “taxTotal”: {
          “value”: 0.00,
          “currency”: “GBP”
        },
        “refundedTotal”: {
          “value”: 0.00,
          “currency”: “GBP”
        },
        “grandTotal”: {
          “value”: 19.00,
          “currency”: “GBP”
        },
        “channelName”: “Squarespace”,
        “externalOrderReference”: null,
        “fulfilledOn”: null,
        “priceTaxInterpretation”: “EXCLUSIVE”
      }
      // … possibly more orders …
    ],
    “pagination”: {
      “page”: 1,
      “page_size”: 50,
      “total”: 12345,
      “nextPageCursor”: “eyJpZCI6IjY2YzNl…”
    }
  }

1. POST Requests:
   Allows Business Central to push new or updated data back to Squarespace. Examples include updating product details or inventory levels directly from BC such as;

• Create Product:

• POST : https://api.squarespace.com/1.0/commerce/products
• {
  “name”: “Sample Product”,
  “description”: “Product description goes here.”,
  “sku”: “SKU-001”,
  “variants”: [
  {
  “pricing”: {
  “basePrice”: 29.99
  },
  “inventory”: {
  “quantity”: 10,
  “unlimited”: false
  }
  }
  ],
  “productType”: “physical”
  }
• Update Product
• POST: https://api.squarespace.com/1.0/commerce/products/{productId}
• {
  “name”: “Updated Product Name”,
  “description”: “Updated description.”,
  “variants”: [
  {
  “id”: “variant-id-here”,
  “pricing”: {
  “basePrice”: 34.99
  }
  }
  ]
  }
• Upload Product Image
• POST : https://api.squarespace.com/1.0/commerce/products/{productId}/images
• BC uploads an image file (Base64 or multipart).
  Squarespace attaches it to the product and returns an imageId.
• {
  “filename”: “product-image.jpg”,
  “imageData”: “BASE64_STRING_HERE”
  }
• Update Inventory
• POST : https://api.squarespace.com/1.0/commerce/inventory

• BC pushes updated stock values for multiple products or variants.

  Inventory updates are batched, meaning you can send multiple items at once.

• {
  “adjustments”: [
  {
  “sku”: “SKU-001”,
  “quantityDelta”: -1
  },
  {
  “sku”: “SKU-002”,
  “quantityDelta”: 5
  }
  ]
  }

1. DELETE Requests:
   Enables efficient cleanup and management of store data by allowing deletion operations, such as:

• Delete Product: Remove obsolete products from Squarespace.
• DELETE : https://api.squarespace.com/1.0/commerce/products/685aacb622419c70c6517d7d
• Status: 204 No Content
• Delete Image: Delete product or store images to streamline media management.
• DELETE : https://api.squarespace.com/1.0/commerce/products/691721051d55bf566b73de5c/images/69172138b0c4a7226c599192
• Status: 204 No Content

API Permissions Required for Business Central ⇆ Squarespace Integration

Seamlessly integrating Squarespace Commerce with Microsoft Dynamics 365 Business Central requires a robust, secure, and fully controlled API authentication framework. This integration relies on two layers of authentication to ensure safe and reliable data synchronization across products, inventory, orders, and pricing. Squarespace employs API keys that act as primary authorization tokens, along with secret keys that provide an additional layer of security. These keys authenticate every request your system makes, enabling capabilities such as reading and updating products, managing inventory, syncing store pages, and retrieving orders — all without requiring extra permissions. For example, a sample Squarespace API key could be sqsp_test_9Fxs29JDh29skL29A, which developers can use in sandbox environments for testing. Meanwhile, Microsoft Dynamics 365 Business Central leverages Basic Authentication through a combination of a BC API username and a Web Service Access Key, ensuring that every data exchange is secure. To enable complete synchronization of products and inventory, the BC API user should have permissions like Financials.ReadWrite.All or full system access, allowing your integration to push product updates, adjust stock levels automatically, and retrieve operational data efficiently. By combining Squarespace’s secure API key model with Business Central’s read/write financial permissions, businesses achieve a fully automated workflow where product data, inventory levels, and customer orders remain accurate across all channels in real time. This integration not only eliminates manual data entry but also ensures enterprise-grade security, compliance, and seamless communication between both platforms, ultimately enhancing operational efficiency and enabling your eCommerce operations to scale with confidence.

Secure RESTful Communication

• The integration relies on secure HTTPS endpoints to transmit data between Squarespace and Business Central.

• OAuth 2.0 and API Key authentication ensure only authorized access to store data.

• Data synchronization occurs both ways — Squarespace to Business Central and Business Central to Squarespace — providing real-time, accurate, and reliable information across platforms.

Benefits for Business Operations

• Real-Time Synchronization: Orders, inventory, and products are instantly updated between Squarespace and BC.

• Data Accuracy: Reduces manual entry errors and ensures consistency across systems.

• Streamlined Workflow: Administrators can manage products, inventory, and orders efficiently from within Business Central.

• Scalable Integration: Supports multiple stores and can easily extend to additional data types or future e-commerce features.