Data Formatting Standards

When setting up or interpreting Zaps in White Swan's integration with Zapier, it can be helpful to understand the expected formats for various data types. We follow common format standards but for your reference, here's a quick guide:


Numbers

  • Format: Decimal numbers (e.g., 12345.67 or 1000000)

  • Note: Avoid using commas or other delimiters. Use a period (.) for decimal points.


True/False (Boolean)

  • Format: true or false

  • Note: These values might show up capitalized in the Zapier interface, but will generally send lowercase.


DateTime

  • Format: YYYY-MM-DDTHH:MM:SS.sssZ (e.g., 1980-10-10T04:00:00.000Z)

  • Note: This format represents the ISO 8601 date-time format, which is a standard format used across web applications. The 'T' separates the date and time, and the 'Z' indicates that the time is in UTC.


Address

  • Format: A full or partial address as recognized by Google Maps (e.g., "1600 Amphitheatre Parkway, Mountain View, CA").

  • Note: If not all components of the address are provided, White Swan's systems will make a best guess on the missing details. It's recommended that the provided address is as complete as possible for the most accurate results.


Text

  • Format: Alphanumeric characters, symbols, and special characters.

  • Note: This field is versatile and can accommodate a wide range of input. Ensure the content is relevant and contextually appropriate for the intended use.


Dropdown (Multiple-Choice) Fields

  • Format: Pre-defined options presented in a dropdown menu.

  • Note: For the Create and Search actions in Zapier, ensure that data passed from dynamically from another app matches one of the alternatives provided in the documentation or that is visible in the Zapier interface. Using options outside of these predefined choices may result in errors or unexpected outcomes.


Line Items (Object Lists)

  • Format: One or several items with several inputs for each item

  • Note: When line items are shown in the tables of this section, the input for each item is shown starting each input with -.

Last updated