Overview
A Catsy Category can be transferred to an iPaaS Product Category using an Add/Update sync method through manual sync and polling. This mapping supports the automated synchronization of Category records from Catsy into iPaaS as Product Category.
Integration Flow
Product Category Creation: A new Product Category record is created in iPaaS with the mapped details.
Product Category Resolution: The system finds the corresponding Product Category in iPaaS using their external ID or Name.
Integration Settings
Mapping Status: Enabled.
ID Format: When manually transferring data to iPaaS.com for a Catsy Category, such as Category ID Cat4000696937, it is essential to enter the correct Category ID (e.g., " Cat4000696937 ") into the "iPaaS.com" input field on the iPaaS.com Manual Sync page.
Conflicting Mappings: This mapping applies only to Product Category. Ensure no other mappings target the same iPaaS entity to prevent data from being overwritten.
Authentication & Security
Catsy uses API key authentication to generate an access token, which is then used to authorize all Catsy API requests in transfer operations.
Mappings
Catsy Category To iPaaS
Mapping Type | Source (Catsy) | Destination (iPaaS.com) | Description |
Dynamic Formula |
| Description | Returns a string value that combines the word "Catsy" with a portion of the AltId value, starting from the fourth character (index 3). |
Field |
| ParentId | if the parent ID doesn't start with C for Cat or Col (alternate id's for processing category and collections), then use the nullable Default Parent Category For Collections or Default Parent Category For Categories. |
Field |
| Buckets (Custom Field) | Checks whether the Buckets collection is null. If it is null, it returns an empty string (""). Otherwise, it joins all the elements in the Buckets collection into a single string, separated by commas. |
Field | GetAdditionalPropertyValue(AdditionalProperties,'key') | Key (Custom Field) | Retrieves the value of a specific additional property from the AdditionalProperties collection using the provided 'key'. It returns the corresponding value associated with that key. |
Field | Name | Name | The Catsy name will be added to the Name field of the iPaaS Product Category. |
Error Handling
Invalid Category ID
Description: This error occurs when the Category cannot be resolved via external ID or name.
Resolution: Ensure the Category exists and mapping is correct.
Validation Rules & Testing
Validation Checklist
Category ID is resolved (via external ID or name).
Test Scenarios
Valid Category: Syncs successfully.
Invalid Category ID: The Category is rejected, and an error is logged.
Additional Notes
Ensure the Category ID or name exactly matches the system to prevent sync errors.