ODBC Driver for Square

Build 26.0.9770

WorkweekConfigs

Query and update the workweek configurations in Square.

Table Specific Information

Select

The driver will execute all filters to this table client-side, in memory.

Retrieve all workweek configurations:

SELECT * FROM WorkweekConfigs

Update

Modify the details of an existing workweek configuration by providing the Id of the configuration:

UPDATE WorkweekConfigs SET StartOfWeek = 'MON', StartOfDayLocalTime = '09:00' WHERE Id = 'FY4TZZMN9955Y'

Columns

Name Type ReadOnly Description
Id [KEY] String True

The UUID for this object.

StartOfWeek String False

The day of the week on which a business week cuts over for compensation purposes.

The allowed values are SUN, MON, TUE, WED, THU, FRI, SAT.

StartOfDayLocalTime String False

The local time at which a business week cuts over. Represented as a string in HH:MM format (HH:MM:SS is also accepted, but seconds are truncated).

Version Integer False

Used for resolving concurrency issues. The request fails if the version provided does not match the server version at the time of the request. If not provided, Square executes a blind write; potentially overwriting data from another write.

CreatedAt Datetime True

A read-only timestamp in RFC 3339 format; presented in UTC.

UpdatedAt Datetime True

A read-only timestamp in RFC 3339 format; presented in UTC.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770