Clarizen Connector

Clarizen Connector

Connecting to Clarizen

Set up your Clarizen connector using your normal Clarizen username and password.
You'll be able to select which environment you want to connect to if you have access to multiple Clarizen sites.

Origin Queries

Origin queries use standard query (SQL) syntax. However, Clarizen's API does not allow you to do a Select *, you must specify which fields are needed.
You can use the Query Builder to see a list of tables and fields.

Data Formating

Many of the Clarizen fields will have formatting around the field values. For example, a lookup/dropdown field will look like { "id": "/Phase/Analysis" } where Phase is the name of the list and Analysis is the field value. A currency field value will look like { "currency": "USD", "value": 30800.0 }

Formatted Origin Data

When you reading data from Clarizen, you will need remove the unnecessary text via scripting.

Here's an example extracting the value from a lookup/dropdown type field:
  1. object ScriptedField()
        string value = Starfish.OriginData["PROJECTTYPE"].ToString();
        value = value.Replace("\"","").Replace(System.Environment.NewLine,"").Replace("{  id: /ProjectType/","").Replace("}","").Replace("/","").Replace("-","");
        return value;
Here's an example extracting the value from a currency field:
  1. object ScriptedField()
        string value = Starfish.OriginData["C_PROFESSIONALSERVICESTOTAL"].ToString();
        value = value.Replace("\"","").Replace(System.Environment.NewLine,"").Replace("{  currency: USD,  value: ","").Replace("}","");
        return value;

Formatted Destination Data


You do not need to include the full formatting when writing to a lookup/dropdown field in Clarizen, just the table name and value. For example, you might provide a resulting value that looks like this: /AccountStatus/Customer where AccountStatus is the table name and Customer is the value. Make sure the value is an available option on that list/table.

    • Related Articles

    • Sage 300 web service setup and configuration

      Setting up Sage 300 web service test Get ready - Prep Sage 300 credentials Sage 300 SQL database Company Username and password System Prereqs .NET Framework 4.7.1+ IIS with ASP.NET enabled. Installed somewhere where the Sage 100 client has also been ...
    • Gainsight Connector

      Gainsight's Customer Success Software empowers companies to increase revenue, decrease customer churn, and drive advocacy.  Gainsight is a cloud-based application and available for your migrations and integrations through the StarfishETL Cloud ...
    • Act! Connector

      ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: Starfish does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium (v18+) using ...
    • Smartsheet Connector

      Smartsheet Origin When authenticating the Smartsheet connector in Starfish, you must clear out the OAuth Access Token/Personal Access Token and the Oauth Refresh Token, Save, then edit again, click Authenticate Now, and follow the prompts.
    • Hubspot Connector

      Hubspot Connector Note: As of September 8, 2020 the Hubspot API does not allow external applications to write into their Quoting module.  See below. Overview The StarfishETL Hubspot Connector enables you to easily connect to Hubspot for integrations ...