February Update - new integrations, CLI, and more!

Hey hotgluers! Here are the updates:


We have a lot of new fantastic features and improvements that we rolled out this month. Here they are:
  • The first edition of the hotglue CLI
  • Improved speed and stability of registration flow
  • Added a personal API key on an account level
  • Added support for creating symlinks across tenants
  • Added allowing tenants to change field map in the widget
  • Added support for larger job history list
  • Updated our integrations pages
  • Improved stability of provisioning jobs (less stalled jobs)
  • Added the ability to filter flows shown in hotglue-elements React component
  • Added an endpoint to apply a new sync schedule for all tenants using a flow

We also have 22 new integrations 🎉 

  • Travefy tap
  • Travefy target
  • Auth0 tap
  • Cognito tap
  • Cin7 tap
  • Microsoft Dynamics 365 Business Central tap
  • Firebase Auth tap
  • Firestore tap
  • Firestore target
  • Gambio tap
  • Linear tap
  • Magento tap
  • MongoDB tap
  • MongoDB target
  • Ongoing WMS tap
  • Postgres tap
  • SAP S/4HANA Cloud tap
  • SFTP Files tap
  • Shoplazza tap
  • Shoptet tap
  • Zoho CRM tap
  • Zoom tap

Integration updates and bug fixes

  • tap-stripe - added support payment intents
  • tap-netsuite - fixed a bug with the incremental syncing
  • tap-prestashop - fixed a bug with the schema
  • tap-reviewsio - fixed a bug with the schemas
  • tap-shop - updated handling for rate limits
  • target-bigquery - added support for incremental updates
  • target-postgres - added support for setting a primary key
  • tap-salesforce - enabled for sandbox accounts
  • tap-mixpanel - fixed a bug regarding ignoring malformed records from their api

Stay tuned for more updates next time 🍻

Sendinblue, Reviews.io, Iterable, and more!

Happy Friday hotgluers! Here are the updates:

  • Added ability to run multiple target jobs for one user concurrently! 🚀 
  • New integrations have arrived
    • tap-sendinblue allows you to pull lists, list members, and campaigns from Sendinblue!
    • tap-iterable
    • tap-blob-storage
    • tap-reviewsio allows you to pull merchant and product reviews from Reviews.io!
    • target-salesforce now allows you to push tasks directly to Salesforce!
    • target-woocommerce now allows you to push products directly to WooCommerce!
  • Integration updates and bug fixes
    • target-queue-storage has been updated to use multi-threading to handle larger payloads in less time 🎉
    • target-s3 now supports using SSE and allows users to set an ACL option
    • tap-googleads has been updated to use the new Google Ads API (instead of the older Adwords API, which has been deprecated by Google)
    • tap-netsuite has been updated to include internalId in payloads
    • tap-sftp has been updated to automatically detect encoding to support non UTF-8 encoded CSV files
    • tap-mixpanel has been updated with new error handling to catch unexpected responses from Mixpanel's API

Stay tuned for more updates next time 🍻

Job Logs Revamp, Shopify target, and bug fixes

Happy Friday hotgluers! Here are the updates:

Revamped Job Logs interface

  • Revamped job logs view, designed to handle longer job logs 🎉
    • Added search functionality to job logs
    • Added ability to read job logs chronologically or reverse chronologically
  • Added setting to automatically enable default sync schedule when tenants link a source
  • Fixed bug with OAuth target settings not working
  • Added support for tap Statflo – currently supports pulling Customer Activity
  • Added support for target Shopify – currently supports pushing products
  • Updated tap-intacct to dynamically pull and use available fields
  • Fixed bug in tap-mixpanel causing errors when pulling cohort_members
  • Fixed bug in tap-blackbaud causing errors due to a dependency mismatch

Stay tuned for more updates next time 🍻

Shopify OAuth, ISPolitical, and expanded coverage

Happy Friday hotgluers! Here are the updates:

  • Updated our docs and API reference 🎉
  • Updated sidebar to include direct links to book a support call and access the docs
  • Added support for using Shopify OAuth apps instead of only allowing API keys
  • Added support for target ISPolitical
  • Added new endpoints to manage state.json of sources via API
  • Updated UI for using testing tokens with OAuth apps
  • Expanded coverage of tap-intacct to include ARINVOICE, ARADJUSTMENT, CUSTOMER, and ITEM
  • Expanded coverage of tap-blackbaud to include education, lifetime giving, and fundraiser assignment

Stay tuned for more updates next time 🍻

Mixpanel, SFTP, and MySQL support + bug fixes

Happy Friday hotgluers! Here are the updates:

Updated Flow details page

  • Added support for tap Mixpanel and SFTP 🎉 – docs coming soon 📖
  • Added support for target MySQL 
  • Restructured the Flow details page to be more intuitive
  • Improved tenant search functionality
  • Enabled passing state data directly from hotglue API to a job
  • Fixed issue with clearing webhook settings in environment settings page
  • Fixed bugs with modifying sync schedules in job sync schedule page
  • Fixed error when starting multiple Jupyter workspaces for the same flow
  • hotglue-elements version 0.0.14 released 🚀
    • Improved load time on first open of Connections component

Stay tuned for more updates next time 🍻

Airtable, Google Sheets support + misc bug fixes

Happy Friday hotgluers! Here are this week's updates:

  • Added support for target Airtable 🎉 – you can now push data directly to an Airtable base/table. Check out the open source Singer target on GitHub
  • Added support for tap Google Sheets – you can now sync data from a Google Sheet! Docs coming soon 📖 
  • Added support for variables in the dataset ID for target BigQuery – similar to path prefixes in target S3/Cloud Storage/Blob Storage (ex. {tenant_id}, {flow_id})
  • hotglue-elements version 0.0.11 released 🚀
    • When user clicks source, a loading icon is shown to let them know the hotglue widget is loading (load time improvements are in the works)
    • Allow styling the loading container
    • Added listeners for onPopupClose and onWidgetClose
  • Fixed bug where failing to link a testing OAuth source in the admin panel showed the error as [Object] object instead of displaying the real error
  • Fixed wrong API error code being sent (500 instead of 400) on BadRequest

Stay tuned for more updates next week 🍻 

BigQuery support, bug fixes, and improvements

Happy Friday hotgluers! 🚀

This week we've got a few updates to share:

  • Added support for tap BigQuery and target BigQuery 🎉
  • Procore tap now supports syncing from the root project directory
  • Added trial counter for new users so they can upgrade from within hotglue
  • Fixed bug where changing the OAuth tokens for a source reset the Python script being used
  • Fixed bug causing default environment to error on registration
  • Updated verification email formatting 🔥
  • Fixed bug with preload option in hotglue widget
  • Added ability to consume JWT token in widget to edit secret configs (ie. API keys for sources like Chargebee)

Stay tuned for more updates coming in the next few weeks! 🍻 

General improvements

Happy Tuesday hotgluers!

We're making an effort to be more transparent with our users regarding changes to the product and how things are going at hotglue!

To that end, I'd love to share some improvements made over the last week:

  • The Sources page is now categorized into several types of sources: Accounting, Sales & CRM, Marketing, Billing, Analytics, and more 🎉 
  • Switching to a tenant view now shows a hovering alert to be more apparent than updating the header (where environment name is shown)
  • Typed + required fields are now supported in the hotglue widget for API sources
  • Quickbooks, and Xero targets have been updated to automatically rollback failed Journal Entry postings
  • HubSpot tap updated to allow fetching companies_properties
  • Job download artifacts will now include Singer tap information, to enable local reproduction of issues (catalog.json, fieldMap.json)

Stay tuned for more updates soon! 🚀