Census changelog
Census changelog
www.getcensus.com

Improvements to HubSpot, Netsuite, Salesforce, Shopify, Userflow, Zendesk

 

Improvement

  
  • HubSpot: Companies many to many relationships
  • Netsuite: Support for all objects - Custom Field Select Boxes, Subscription Objects, Line Items, Change Order
  • Salesforce: Polymorphic lookups
  • Shopify: Orders and inventory levels
  • Userflow: New list type
  • Zendesk: Ticket Comment

πŸŽ‰ New Connectors in July: Jira, Apollo, Ortto, Zoho, Datastore

 

New

  

Changelog_ New connectors July 2022.png

πŸ‘‰ See all of our destination connectors

πŸ—„οΈ Databricks Support for Sync Logs: audit and troubleshoot your syncs in your lakehouse

Databricks users rejoice! Sync Logs are now available in your favorite lakehouse. To enable, navigate to the Connections page in Census, click to edit your connection, and toggle "Write logs in this warehouse."

Screenshot 2022-07-08 at 5.55.43 PM.png

Census will begin storing detailed information regarding the success and failure of each record in your syncs directly in your Databricks instance.

ℹ️ Sync Logs are only available on Platform plans.

πŸ‘‰ Read the product docs

Quality of life improvement: Google Sheets syncs can "parse" raw input into more readable formats

 

Improvement

  

Now, syncs to Google Sheets (as a destination) can send input exactly as a user would have typed it in the browser, in a more human-readable format.

In this example of a date/time field, this is the difference between before (raw input) and after (parsed):

Before: Raw input

image (1).png

After: Parsed into date/time format

image (2).png

How to turn this on/off in the Census UI

New Syncs

The parse option is now on by default. image.png

Existing Syncs

You can easily turn parsing on in Configuration -> Advanced Configuration. Your data will be updated once you run another sync.

image.png

This change is not just limited to dates. With the new behavior, any string that starts with an equals sign = will be treated as a formula. If you want to send a = string and not have that happen, you need to switch off the advanced parsing configuration and use raw input.

No more weird formatting in Google Sheets! πŸ™Œ

Improvements to Webhooks, SendGrid, Netsuite, Oracle Fusion Cloud, and Close

 

Improvement

  

Webhooks: Now supports destinations that don’t implement HEAD

SendGrid: List Support

Netsuite and Oracle Fusion Cloud: New objects, custom fields

Close: Support for Opportunities

πŸŽ‰ New Connectors in June: Close, Courier, User Interviews

 

New

  

New connectors June 2022.png

πŸ‘‰ See all of our source and destination connectors

πŸ“£ New integrations with Microsoft: Azure Synapse and Dynamics 365

 

New

  

Census + Microsoft (1).png

βœ… Support for Azure Synapse, Microsoft’s cloud data platform, as a source for Census reverse ETL

βœ… A connector for Microsoft Dynamics 365 as a destination, to deliver more engaging experiences using warehouse data in the CRM

πŸ‘‰ Read the blog for use cases and more information

πŸͺ„ Create a new Census sync in 1 step with "sync.new"

 

New

  

Psst – type sync.new into your URL bar right now.

2022-06-17 15.01.39.gif

sync.new in any browser will automatically redirect you to app.getcensus.com/syncs/new to create a new Census sync. If you’re not logged in, you’ll be prompted to log into Census first.

From 3 steps to just 1, now it's even easier and faster to create a new sync.

πŸ‘‰ Read the blog to learn more.

❄️ Snowflake Stream Triggers: A better, faster way to sync Snowflake data continuously

 

New

  

In sync with the Snowflake Summit in Las Vegas, we’re excited to announce support for Snowflake Stream Triggers to kick off a reverse ETL sync only when your data changes β€” which is especially useful for data that's updated on an irregular frequency but needs to be synced ASAP.

This is a strictly superior way to accomplish continuous syncs that's both cheaper and faster than previous methods. πŸ™Œ

πŸ‘‰ Read the blog for more!

πŸŽ‰ New Connectors: Userflow, Planhat, SendGrid, Help Scout, Oracle Fusion Cloud, and Amazon Athena (source)

 

New

  

New connectors May 2022.png

πŸ‘‰ See all of our source and destination integrations