SunLync API V2

New optional field for the membership insert endpoint and optional blank-value clearing on the client update endpoint.

New Features

• Feature Added an optional activeDate field to POST /slapi/clients/insertmembership. When provided, it sets the membership's active date. If the active date is in the future, the membership is created with a status of Purchased and becomes active on that date; otherwise it is active immediately.
• Feature Added an optional clearBlankFields flag to POST /slapi/clients/updatedemographics. By default, blank values continue to be ignored. When set to true, an empty string clears the corresponding field for a defined set of optional fields (middle initial, address line 2, home/work/cell phone, and email). Fields sent as null or omitted are never changed.

New optional field for the membership insert endpoint.

New Features

• Feature Added an optional firstDrawDate field to POST /slapi/clients/insertmembership. When provided, it sets the first draw date on the new membership.

New optional field for the referral endpoint and a billing audit log fix.

New Features

• Feature Added an optional cellPhone field to POST /slapi/clients/addreferral. When provided, the cell phone number is stored with the referral.

Bug Fixes

• Fix Audit log entries created when updating billing information are now recorded against the correct audit section.

Bug fix for payment and transaction inserts.

Bug Fixes

• Fix Payments and transactions inserted via the API now record against an API-specific drawer per store instead of a placeholder value. The drawer is created automatically on first use and reused by subsequent requests.

Bug fix for membership upgrade and downgrade.

Bug Fixes

• Fix Fixed SQL when upgrading\downgrading a membership.

New filter option for membership endpoints.

New Features

• Feature Added an optional onlineonly query parameter to GET /slapi/memberships/eft and GET /slapi/memberships/noneft. When set to 1, results are filtered to memberships flagged for online use.
• Feature The same endpoints now also return onlineMembership and listPrice for each membership when those columns are present in the database.

New endpoint for adjusting product inventory after a sale.

New Features

• Feature New POST /slapi/setup/adjustinventoryaftersale endpoint reduces a product's on-hand quantity following a sale. Requires quantity, storecode, productNumber, employeeNumber, and receiptNumber.

Bug fixes for membership upgrade and downgrade endpoints.

Bug Fixes

• Fix Resolved a 500 error on the upgrade-membership and downgrade-membership endpoints that affected customers with certain database schema variants.
• Fix Upgrading or downgrading a membership now correctly populates the store code on the new membership and any associated package records. Previously these records were created with a missing store code, causing them to be excluded from related lookup endpoints.

Follow-up performance refinement for billing info.

Performance

• Perf Further reduced per-request overhead in GET /slapi/clients/billinginfo when EnableEncryption is disabled. Builds on the v1.0.0.4 fix.

New cross-market client search endpoint, billing-info performance fix, and improved connection-failure handling.

New Features

• Feature New GET /slapi/clients/marketsearch?email=X endpoint searches all configured markets in a single request and returns matching clients tagged with their market. Eliminates the need to issue one search per market on multi-market deployments. Available when EnableMultiMarkets is enabled.

Performance

• Perf Significant performance improvement for GET /slapi/clients/billinginfo and POST /slapi/clients/billinginfo when EnableEncryption is disabled. The endpoints now respect this setting and skip unnecessary encryption work on both reads and writes.

Bug Fixes

• Fix Stability Database connection failures now return a clean 503 Service Unavailable response with a Retry-After header instead of dropping the connection.

Stability fix for encryption-related crashes under concurrent load.

Bug Fixes

• Fix Stability Resolved access violation in PolarCryptoLight.dll that could cause the API process to crash under concurrent load. Encrypt and decrypt operations are now serialized to prevent thread-safety issues in the underlying COM library.

Performance and stability improvements targeting high-load environments with multiple API instances behind a load balancer.

Performance

• Perf Enabled database connection pooling for multi-market configurations. Connections are now reused across requests within the same market, eliminating the overhead of a full TCP/MySQL/SSL handshake on every request.
• Perf Added a configurable concurrency cap to prevent server overload during traffic bursts. When the maximum number of concurrent requests is reached, the API returns a fast 503 response instead of queuing indefinitely, keeping the server responsive and preventing load balancer failover cascades.

New Features

• Feature New POST /slapi/clients/insertclientpackage endpoint for inserting client packages via the API.
• Feature The GET /slapi/status endpoint now returns activeRequests and rejectedRequests counters for real-time monitoring of server load and throttling activity.
• Feature Added optional MySQL connection ID diagnostic output. When enabled, each response includes the underlying MySQL connection ID, useful for verifying connection pooling behavior.

Bug Fixes

• Fix Fixed uninitialized variable in request parameter validation across all POST endpoints. In rare cases, required field validation could be bypassed.
• Fix Fixed date comparison queries for MySQL 8.x strict mode compatibility. Date fields compared to empty strings are now handled using CAST to avoid strict mode errors.