May 2nd 2024
Welcome to our April Melt! Here’s what you may have missed from the past month.
We added 5 new integrations to our library and the open-source Singer community in April.
Logic4
Keyna from our integrations team built a tap and target for Logic4 (logic4.nl), an e-commerce and ERP platform based in the Netherlands. You can use the connectors to fetch inventory, purchase, and sales information, and write back transactions like purchase orders.
Bird (formerly MessageBird)
Keyna built a target for Bird (bird.com), an omnichannel communications platform and CRM. Built on Hotglue’s target SDK, the target lets you push any data, like new contacts, to your customers’ Bird CRM accounts.
Appsflyer
Adil from our integrations team built a target for Appsflyer (appsflyer.com), a mobile marketing analytics tool. Combined with our existing Appsflyer tap, the new target allows you to offer bi-directional connectivity with your customers’ Appsflyer apps.
Connectwise
Our partner, Plentive, built a connector to read data from Connectwise (connectwise.com), an MSP management solution. The tap fetches data such as projects, activities, and time entries.
ClientTether
Chauncy from Plentive also built a connector for ClientTether (clienttether.com), a CRM for franchises. The connector fetches general CRM data from your customers’ ClientTether accounts.
We also released a Confluence connector out of beta, thanks to a fork of Edgar Ramírez Mondragón’s Singer tap.
We released two new API endpoints last month.
catalog/search
Run fast, granular searches across catalogs to search for streams, fetch types, and more. This is particularly useful for large catalogs that are too big to be served in a single linkedSource fetch.
discover/kill
Just like the Kill Jobs endpoint, you can use this to end any running discovers for a linked connection.
You may also notice some minor QoL updates to your log viewing experience:
You have more control than ever over the behavior that your jobs run with.
POST /jobs
When making a POST to `/jobs`, you can define override environment variables. This could be an existing reserved variable (max_record_count, default_export_format) or a custom environment variable used in your ETL.
When setting schedules, you can now configure schedules to run with specific environment variables and job settings, just like manual job runs. Supported params in schedules now include:
override_start_date
override_selected_tables
override_field_map
environment_variables
Got questions, or have requests you’d like to see us build? Reach out to us in Slack or at hello@hotglue.xyz.
See you next month 🙂
- Brendan
Apr 4th 2024
Hey hotgluers,
Welcome to the hotglue melt.
Before we jump into what’s new in hotglue, we have a few major updates that we are slowly rolling out in a limited beta.
Real-time writes remove the need for a job process to POST data using our unified API. If you use our API to write data (not a reverse ETL from a Database or filestore), this lets you see the validations or success responses right when you POST. The limited beta is for Quickbooks and Shopify, with more to come with the general release.
Thereal-time webhook handler runs high-throughput trigger-based workflows without the need for full job processes. This is built on top of our real-time triggers–now they are just much faster, smaller, and more flexible.
If these are relevant to you, and you want to try them out before general release, let us know!
Reach out to us at hello@hotglue.xyz
Now, for what’s new:
With connector-level schedules, you can maintain individual schedules for each connector - either as an alternative or an addition to existing flow-level schedules. This enables use cases like:
If you use emails to track job failures, you may have noticed some changes to the emails you get:
**Restrict upload file types in the widget.
**In Settings > Widget, you can now configure a list of supported file types for file uploads. Use this to only allow discoverable files (csv and excel), or otherwise limit uploads to files that your ETL is prepared to handle.
**Jupyter speed boost
**Your environment and script-level dependencies are now downloaded and cached the first time you run Jupyter. That means that subsequent Jupyter startup times are significantly faster now.
**Memory failure auto-retriggers
**Large jobs occasionally need more memory and storage than is provisioned by default. In Settings > Jobs > Error management, you can now configure jobs to automatically retrigger with increased memory on OOM failures.
—
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Apr 3rd 2024
Hey everyone! Welcome to our monthly hotglue melt. Here’s a rundown of the hotglue features you may have missed.
Over the past few weeks, our backend team has pushed some big changes to help make jobs faster. We’ve seen job time savings of anywhere from 40 seconds to over 3 minutes, and there’s more to come. The improvements to date include:
Next steps: We’re working through individual connectors to add more concurrency, and adding some additional optimizations to the job executor.
Sage 50 UK and Quickbooks Desktop are installed executables available on our Basic Plan and above. They can now be linked in under a minute and managed remotely, with:
Here’s a demo of how this works for QBD.
Over the past few weeks, our integrations team contributed three new connectors to hotglue’s library and the Singer community:
Our customer Plentive also contributed four new Singer connectors, which are all available to use in any hotglue environment:
Lastly, we improved some existing open-source connectors and added them to the hotglue library:
Frontend:
Jobs and stability:
A new environment setting to retrigger jobs automatically when they hit memory limits
When a catalog’s size surpasses AWS API Gateway’s max limits, it is now trimmed to a “lite” version in API responses. The full catalog is still used by syncs and ETL scripts.
Added code coverage and mock classes for Salesforce Apex triggers and classes
Google sheets discovery is now up to 12x faster in the widget.
We added new CLI functions and API endpoints, including:
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Apr 3rd 2024
Welcome to our year-in-review 2023 hotglue melt!
To those who’ve been around for a while, thank you for building your integrations on hotglue.
You make hotglue a better product with your feedback, and we’re always excited to see the creative ways you put hotglue to use.
As we begin the new year, we wanted to take a brief moment to look at how hotglue has changed over the last year. As always, feel free to reach out in Slack with your questions and suggestions for 2024!
Our integrations team built 83 open-source connectors. That included support for 61 net new SaaS and on-premise applications.
hotglue jobs are now much faster, thanks to a rebuilt runtime and deployment pipeline.
We added new modules across the admin panel, including the Jobs, Errors, White-Label, Connector Settings, and Environment Variables features.
Our new bi-directional flows make reading and writing data with your customers’ integrations dead-simple.
The hotglue team built a new Singer target SDK, making for simple, transparent exports to our most popular SaaS connectors.
Before 2023, hotglue flows always consisted of a linked source and a linked target. This made for dead-simple setups when you only needed to move data in one direction.
However, bi-directional integrations where you need to consistently read and write data were not simple to set up in hotglue: you needed two separate flows with symlinked credentials.
Now, with hotglue bi-directional “V2” flows, this is supported out of the box. Rather than thinking about target flows, `linkedSources`, and `linkedTargets`, every integration that a customer links in a V2 flow is simply a connector.
Bi-directional flows come with a new set of “V2” endpoints. If you’re not already using V2 flows, you can try them out by creating a new flow, and leaving the “bi-directional” toggle turned on. Let us know if you want to discuss migrating your existing flows over!
In 2023, we pushed some major updates to how you use the hotglue admin panel. You may have noticed the new jobs and errors panels, but there are other features spread through your dashboard that you may find useful:
Last year, we frequently heard that you wanted jobs to kick off and run faster. We rebuilt our job runtime from the ground up with that in mind. The new version of the executor has two main benefits:
We also re-designed our connector deployments using Jenkins, which removes dependency installation from the job runtime.
You can check which executor your jobs use by parsing your job status webhooks. If the `task_definition.id` shows `hotglue-executor-v3`, you’re using our modernized architecture!
The main challenge with using Singer targets has historically been understanding which records were created, and where validations happened. Traditional Singer targets either succeed (data probably loaded in) or fail (some data may have been loaded in, but not all of it). Hotglue’s new target SDK is designed to fix this.
The root concept in Hotglue’s target SDK is the `target_state`. The target state contains important data about what the target did, including:
In 2023, we built or upgraded 32 targets using hotglue’s target SDK. If you’re using a target that isn’t on this list yet, let us know! It may already be in our pipeline:
If you’re not using the widget or not using many widget features, you may have missed the updates we’ve been shipping all year: https://www.npmjs.com/package/@hotglue/widget?activeTab=versions
Note for React users: At the time of writing, the current version of @hotglue/widget is v1.4.46. You may need to update your widget version to access some of these features.
We added 61 new integrations in 2023, including 11 brand new bi-directional integrations, 29 new taps, and 21 new targets. We also rebuilt many of our most well-used connectors, which are not listed below.
Accounting and Inventory:
E-commerce and Order Management:
CRM and Email:
Database and Data Storage:
Support and Project Management:
Other Integrations:
Thanks so much for reading! These are some things we have coming up:
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Sep 1st 2023
Hi team!
Welcome to our monthly hotglue melt. Here are some highlights you might have missed:
6 new taps:
2 new targets:
Credential validation for database connectors, including MySQL, Postgres, and MSSQL.
An optimized deployment workflow for lightning-quick in-job installation. Now supported for Dynamics 365 CRM, Woocommerce, and Hubspot.
Outside of our connectors, we made some other quality-of-life features.:
/linkedSources
and /jobs
API calls to improve speedskip_sync
option in the /jobs
endpointHere are some things to look forward to in the next updates:
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Aug 1st 2023
Hey team!
Welcome to our monthly hotglue melt. Here’s what you might have missed:
5 new taps:
3 new targets:
As always, we’re constantly pushing updates to our open-source connectors. You can check out our latest singer connectors or submit a PR at https://gitlab.com/hotglue and https://github.com/hotgluexyz.
Outside of our connectors, we added some other quality-of-life features:
Here are some things to look forward to in the next updates:
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jul 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
In June, our integrations team added new taps for Invoiced, Dynamics (NAV) on-premise, Altium (Nexar). Additionally, we added new targets for Sage 50 UK, PowerBI, Dynamics (NAV) on-premise, Square (unified schema), and Constant Contact.
We also released improvements to the following connectors:
Taps: A (new) Netsuite tap, Xero, Exact, Zendesk, SFTP, Square, Altium, Mixpanel, a (new) Shopify tap, and Zoho CRM.
Targets: Odoo, Exact, Squarespace.
Outside of our new connectors, the team made several improvements including:
The team continued to add improvements to the new hotglue target SDK. For supported connectors like Quickbooks, Xero, Picqer, Salesforce Commerce, and Odoo, you can now:
Allow your users to create their own field maps, map custom fields, and manage complex integrations more simply with new widget improvements:
We also added a few more goodies, including:
Here are some things to look forward to in the next updates:
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jun 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
In May, our integrations team added new taps for Amazon Vendor Central, Azure Active Directory, and Squarespace. Additionally, we added new targets for Etsy, Exact, and Picqer.
We also released improvements to the following connectors:
Taps: Salesforce, Zoho CRM, Stripe, Marketplacer, S3, Square, Stamped, Quickbooks, and SFTP.
Targets: Xero, Montapacking, Moosend, Quickbooks, and SFTP.
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
Got ideas? Shoot us a message in Slack or send us suggestions at hello@hotglue.xyz.
See you next month! 👋
May 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt! Here's what you may have missed:
In April, our integrations team added new taps for Etsy (unified API schema) and Bol. We also added new targets for Marketplacer (unified API schema), Redshift, and Salesforce Commerce Cloud.
We also released improvements to the following connectors:
Taps: Montapacking, BigCommerce, QLS, Amazon Seller Central, Looker, Stripe, Ongoing WMS, Abra, Apple App Store,
Targets: Prestashop, Salesforce Sandbox, Campaign Monitor, Quickbooks, Postgres, SFTP
Outside of new connectors, the frontend and backend teams made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Apr 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
You can now add and configure global environment variables to use inside your ETL scripts. For new customers, default scripts include support for DEFAULT_EXPORT_FORMAT
.
You can also use any custom variables that you need, like private keys, environment names, or API endpoints.
Environment variables are configurable in your settings, under variables. You can create as many variables as you need.
In March, our integrations team added new taps for Abra, Affinity, Apple App Store, Chargify, Faire, Gladly,Marketplacer, and Picqer. Additionally, we added new targets for Affinity, Klaviyo, and Campaign Monitor.
We also released improvements to the following connectors:
Taps: Exact, Salesforce, Looker, Amazon Seller, Bigcommerce, Quickbooks, Hubspot, Salesforce Commerce, and Pipedrive
Targets: Postgres, Quickbooks, Google Sheets, and Pipedrive
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
More tools to manage logs and understand failed jobs
Expanded support for target states, which means detailed information about records you create in external systems
UI improvements to the Tenant and All Jobs page
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Mar 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We're excited to announce a new way to set up your flows. Instead of connecting to "sources" or "targets," your users can now connect to any available "connector" in the dashboard and run jobs both ways for that tenant.
Bi-directional flows are enabled by default for new users. Let us know if you're already using hotglue and want to try out these new flows.
Also released this past month, you can now create multiple connections to the same connector using "subtenants." This can be used for customers with multiple shops, or parent companies with multiple business entities.
You can turn on subtenants in the widget settings.
In February, our integrations team added new taps for Salesloft and Salesforce Commerce. Additionally, we added new targets for Clickup, Jira, Google Cloud SQL (Postgres), Blackbaud, and QLS.
We also released support for new triggers for Salesforce and Quickbooks
We also released improvements to the following connectors:
Taps: Sage 50 UK, Amazon Seller, Outreach, Montapacking, Salesforce Sandbox, Shopify, Zoho Books, Woocommerce, BigCommerce, Hubspot, BigCommerce
Targets: Xero, Quickbooks Desktop, Quickbooks Online, netoHQ, Snowflake
Outside of our new connectors, the team made several improvements including:
default
tenant jobsHere are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Feb 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
With the new tenant drawer, you can now access metadata, schedules, job history, snapshots, and more straight from the dashboard. This gives you fine-grained visibility into tenant configurations without having to touch the API.
We will use this in the future to offer detailed filters, sorting, and analytics on your catalog of tenants. Let us know what sort of metadata you'd like to filter and sort your tenants with!
In January, our integrations team added new taps for QLS, GoHighLevel, and Shiphero. Additionally, we added new targets for Gong, Pipedrive, Wix, and Quickbooks Desktop.
We also released support for new triggers for Pipedrive, Salesforce, and GoHighLevel.
We also released improvements to the following connectors:
Taps: Hubspot, Dynamics, Netsuite, Chargebee, Wix, Stripe, Google Sheets, Amazon Seller, Quickbooks, Dynamics, and plentymarkets
Targets: Mailchimp and Moosend
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jan 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
Have a new integration you need for your product? Instead of building it yourself, you can use our connector roadmap to request it. We'll add it to our roadmap, and once it's built we'll reach out to you.
If the connector is already on our roadmap, you can use this page to upvote it and get it built faster!
In December, our integrations team added new taps for Google Analytics UA, Capsule CRM, Keap, FollowUpBoss, PowerBI, Montapacking, Fortnox, and Kustomer. Additionally, we added new targets for Quickbooks Sandbox, Odoo, and Montapacking.
We also released support for triggers for Shopify, CapsuleCRM, Keap, FollowUpBoss, Zendesk, and Pipedrive.
We also released improvements to the following connectors:
Taps: Intacct, Asana, Hubspot, Woocommerce, Xero, Chargebee, Amazon Seller, Plentymarkets
Targets: Shopify, NetSuite, Woocommerce
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Dec 1st 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
The docs for unified schemas have a new home! You can now comb through the standardized data models for our most popular CRM, Accounting, and E-Commerce integrations.
Each table has a single schema, which you can use with the jobs endpoint to send data to any supported target via the hotglue unified API.
We are continuously expanding the connectors that support unified schemas – let us know what connectors you want to see on this page!
In November, our integrations team added new taps for Zoho Books, Clockify, MYOB, Quickbooks Desktop, and Close.io. Additionally, we added new targets for Magento, Bexio, Mailerlite, Zoho Books, and Microsoft SQL.
We also released support for triggers for Zoho CRM, Mailchimp, ActiveCampaign, and Close.io
We also released improvements to the following connectors:
Taps: Intacct, Hubspot, Amazon Seller, Shopify, Google Analytics, Open Exchange Rates, Quickbooks, Woocommerce, Google Cloud Storage, Chargebee, Salesforce, and ActiveCampaign
Targets: WooCommerce, BigQuery, and MySQL
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Nov 1st 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We have added the ability to enable and use our Unified Schemas for CRM, Accounting, and E-Commerce integrations directly inside the hotglue admin panel.
Simply enable the Unified Schema toggle in your source settings, and choose the relevant tables. All data will come through in our unified schema rather than the raw source schema.
We are working on expanding the connectors that support unified schemas and what tables we support – let us know if you are interested in using this feature!
In November, our integrations team added new taps for Copper, AgileCRM, Sellsy, PlentyMarkets. Additionally, we added a new unified schema target for Zoho.
We also released support for triggers for QuickBooks, Shopify, and WooCommerce
We also released improvements to the following connectors:
Taps: Salesforce, QuickBooks, Chargebee, HubSpot, Amazon Seller, CIN7, Google Analytics, SFTP
Targets: BigQuery, Snowflake, WooCommerce
Outside of our awesome redesign, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Oct 17th 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We have officially launched support for real-time triggers for several integrations, including: Salesforce, HubSpot, and Shopify. Triggers allow you to automatically run sync jobs when something happens in a source system. For example, as soon as a new contact is created in HubSpot or Salesforce, hotglue will receive a webhook on your behalf, and trigger a job.
We are rapidly expanding support based on demand – let us know if there are any you are interested in!
We have added support for allowing tenants to do simple mappings of their data in the widget. This works for both source flows, where you want tenants to map to your own data schema (for example, a tenant could map a custom Salesforce object to your Contact schema), and for target flows, where you want tenants to map their data in your product to a target.
To learn more or try this beta feature, reach out to us at hello@hotglue.xyz. Public documentation is coming soon!
While sync jobs run, hotglue will automatically track the number of records collected for every stream in real time. This allows you to have more visibility into a particular sync and its progress! This data is also made available via the API. See a sample below:
In September, our integrations team added new taps for FTP, MooSend, PostHog, MySQL, Jotform, and Sellsy. Additionally, we added new unified schema targets for MooSend, WooCommerce, ActiveCampaign, Sage Intacct, and Dynamics 365 Business Central.
We also released improvements to the following connectors:
Taps: HubSpot, NetSuite, Dynamics 365 Business Central, QuickBooks
Targets: BigQuery, NetSuite
Outside of our awesome redesign, the team made several improvements including:
Updated job metric graphs in environment dashboard. New graphs show failing jobs, record counts, and more!
Added new setup guide for new users, which includes videos and guides explaining hotglue concepts. You can always launch the setup guide via the Environment Settings.
Launched new landing pages describing our unified schema features!
Added ability to Clone Flows to other environments
Added ability to store a "snapshot" of reference data required for targets to optimize their runtime. Currently available for target NetSuite, and will be coming to other targets soon!
Updated notification emails for improved look & feel
Added option to allow tenants to trigger full sync jobs in the widget
Updated JupyterLab connections to use SSL
Made source catalog available during ETL runtime
General bug fixes and stability improvements
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Sep 1st 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We have updated our scheduler for triggering jobs to handle the higher volume of scheduled jobs we are seeing.
Note: As a part of this change, we have moved away from AWS EventBridge cron expressions to standard UNIX cron expressions. You will receive email alerts if any of the cron expressions you are using cannot be automatically converted to the new format.
In August, our integrations team added new taps for Sage 50 UK, Dynamics 365 Finance & Operations, Mailstep, and Notion. Additionally, we added new unified schema targets for Dynamics 365 Sales and Shopify.
We also released improvements to the following connectors:
Taps: HubSpot, Google Analytics, WooCommerce, Magento, Chargebee, QuickBooks, and Prestashop
Targets: Salesforce, NetSuite
Outside of our awesome redesign, the team made several improvements including:
Updated billing functionality
Download Job service has been updated to allow you to download cached data from larger jobs (up to 20GB)
hotglue widget updates
HotGlue.link
functionAdded ability to retrigger failed jobs without rerunning the SYNC phase. This is mainly used for testing/updating ETL scripts.
The UI for refreshing field maps for taps has been updated:
General bug fixes and stability improvements
us-east-1
), but were able to avoid an extended outage by switching to the us-west-1
region. To stay updated on outages like this, subscribe to our status page updates.Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Aug 1st 2022
Hi hotgluers!
Welcome to our sixth hotglue melt - we have got some awesome updates to share!
We have updated our landing pages to more closely match our brand and explain the possible use-cases for hotglue. This includes an interactive preview of the new hotglue widget, more emphasis on the developer experience, updated graphics, and more. See a preview below:
In July, our integrations team focused on expanding our unified schemas and library of targets (integrations that push data to other platforms). Notably we have released new versions of targets that use the unified schemas: Salesforce, HubSpot, Xero, and NetSuite.
Additionally, we have released new Magento v1, Wix, GitHub, and Stripe taps that feature better performance and data models. We also released improvements to the Facebook Ads, Amazon Seller, Prestashop, Chargebee, HubSpot, Magento, and Zendesk taps.
Outside of our awesome redesign, the team made several improvements including:
Added support for the gluestick to_singer function to enhance support for typing and setting primary keys when pushing data to targets
Added support for using both etl.py
and etl.ipynb
formats for ETL scripts
@hotglue/widget package updates
Added command to delete deployed ETL scripts to hotglue CLI
Fixed timeout issues when downloading long job logs
Added optional upsert option to toggle sync schedule endpoint to apply default schedule to all tenants
General bug fixes and stability improvements
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jul 1st 2022
Hi hotgluers!
Welcome to our fifth hotglue melt - we have got some awesome updates to share!
In June we welcomed Davi, an awesome full stack engineer, to our team! We are super pumped to have him join us and help the product reach the next level.
We have released the new hotglue widget as an npm package to make the setup process more streamlined. Part of this change includes a totally overhauled Connections
React component, an inline version of the hotglue widget. The goal of the Connections
component is to allow for a more native user experience for tenants. See an example below:
You can learn more about the widget, React component, and the new installation process in the docs: https://docs.hotglue.com/docs/embed-hotglue
Note: The old Connections
component was previously available in the now deprecated hotglue-elements package.
As mentioned in our last update, one of our goals this month was to revamp the Google Sheets integration. We have vastly simplified the user experience for tenants that are connecting their Google Sheets. Beyond that, the new version of the integration also reduces the amount of setup required.
The new Google Sheets integration is already available for use, and we would love any feedback or suggestions you have! Feel free to reach out at hello@hotglue.xyz
As usual, our integrations team added more integrations – notable ones include Google Workspace, Fishbowl Inventory, Gong, Delighted, Google Play Store, Front, Metronome, and iTunes Connect. We also released improvements to the HubSpot, WooCommerce, Salesforce, Iterable, Chargebee, Snowflake, and more.
Outside of our awesome redesign, the team made several improvements including:
Resolved issues with downloading large jobs directly from the hotglue admin panel!
Improvements to job logging:
error
field to the job details returned from the API including the summary log of why the job failedAdded the option to enable a Job History tab in the widget, so tenants have visibility into the sync jobs that have run. See below:
Added PATCH endpoint to allow updating the tenant config. Read more in the docs
Added revoke
parameter to DELETE tenant endpoint which deauthorizes any active OAuth connections before deleting the tenant. Read more in the docs
You can now choose a color to easily identify your hotglue environments in the admin panel, and update their names.
Enabled ability to override the default scopes for the HubSpot connectors in the admin panel
General bug fixes and stability improvements
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jun 1st 2022
Hi hotgluers!
Welcome to our fourth hotglue melt - we have got some awesome updates to share!
As some of you may know, the hotglue team is fully remote with members from the United States, Brazil, Pakistan, and the Philippines. We recently had our first company meetup in São Paulo, Brazil – home to our amazing frontend engineer, Breno!
We wanted to share our first team picture (with everyone wearing their new hotglue swag 😎) from the trip with all of you. None of this would be possible without your support, and we are excited to continue our mission to make building native integrations simpler.
As mentioned in our last update, our product team has been hard at work on a new version of the hotglue widget. Our goals were to radically enhance the UI to give a more intuitive experience for users and deliver a polished interface. Beyond that, we are focusing on increasing the customizability of the widget so you have more control over your users integration experience.
The new widget is already available for use! You can learn how to upgrade on our docs.
We would love any feedback and suggestions you have! Feel free to reach out at at hello@hotglue.xyz
As usual, our integrations team added more integrations – notable ones include SKUVault, SFTP Files, and Zendesk. We also released improvements to the Amazon Seller, Chargebee, Magento, Unleashed, Bexio, Pipedrive, HubSpot Beta, and Fulfil integrations.
Note: We are advising all users of our HubSpot integration to upgrade to our new connector (labeled HubSpot (B) in the hotglue UI). The new connector features performance improvements and a data model that is much easier to work with. If you have any questions, please reach out to us!
Outside of our awesome redesign, the team made several improvements including:
hotglue now integrates with Datadog! You can configure hotglue to push job events (success or failures) directly to your Datadog events to maintain observability in one platform. Learn more in the docs.
We have developed an improved SFTP integration (called SFTP Files), allows users to browse their SFTP server and select the files/directories they want to clone! See a preview below:
You can now use your own S3 buckets to cache job data and snapshots! If you're interested in trying this feature, contact us to help you get it setup :)
Here are some things to look forward to in the next updates:
Improvements to our embeddable UI
Improved Google Sheets integration
Unified schemas
Audit trail for sub-users
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
May 1st 2022
Hi hotgluers!
Welcome to our third hotglue melt - we have got some awesome updates for you all.
Our product team is extremely excited to launch a redesign of the hotglue admin panel! The goal of the redesign was to create a more polished UI with a more intuitive UX. We would love feedback from users as they try it out!
In April, our integrations team added a whopping 27 new integrations! The most notable are:
Outside of our awesome redesign, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Apr 25th 2022
Hi hotgluers!
Welcome to our second hotglue melt - we have got some awesome updates for you all.
In March, we received our official SOC 2 Type II certification! Data security and privacy is an essential component of our dedication to upholding our promise to protect sensitive user data. As we continue to grow as a company, our commitment to security remains steadfast.
Last month, we added 7 new integrations! The most notable are our new Bexio, Amazon Seller, and Freshsales integrations. We've also released updates for our NetSuite, Chargebee, Zoho, and Prestashop integrations, among others.
The product team did some amazing work during March. Here is what they did:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Mar 1st 2022
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:
We also have 22 new integrations 🎉
Integration updates and bug fixes
Stay tuned for more updates next time 🍻
Jan 14th 2022
Happy Friday hotgluers! Here are the updates:
You can now secure your account by enabling Multi-Factor Authentication in your Account Settings 🚀
Added filter to query exclusively for scheduled
jobs
HubSpot target now supports calling discover to get available objects/fields (similar to sources)
New endpoint for creating/updating a tenant config, which is available during runtime of transformation scripts
Bug fixes
GET /tenants
endpoint timeout issue resolved and performance improvedonTargetLinked
correctly – was causing issues in hotglue-elementsNew integrations have arrived 🎉
Integration updates and bug fixes
start_date
formatting for querying users
dataexchange_rate
from credit notescustomer
in journal entriesinventory_level
contacts
dataStay tuned for more updates next time 🍻
Dec 31st 2021
Happy Friday and Happy New Year hotgluers! Here are the updates:
You can now modify your notification preferences! Toggle updates on environment creation and scheduled job failures under Account Settings 🚀
Added count
query param to get jobs endpoint to allow retrieving full job history
Bug fixes
state.json
files from being used by future jobs (discovered with tap-klaviyo)New integrations have arrived
engagements
and contacts
to HubSpotIntegration updates and bug fixes
tap-netsuite
bug fixes:
Item
rate schema fixedtap-sftpnow supports delete_after_sync
option which automatically purges files from remote server after sync is completed
tap-shopifynow supports pulling shop
data and orders in transit
target-netsuite
updates:
subsidiary
fieldtarget-intacctissues with case sensitive posting type and rounding errors fixed
target-shopifynow supports updating inventory_level
Stay tuned for more updates next time 🍻
Dec 17th 2021
Happy Friday hotgluers! Here are the updates:
You can now invite your team members to join your hotglue organization! Find this option under Account Settings 🚀
Secret API Key is now available under your environment settings. Note: any requests from your backend should now be done using the secret API key, not the public API key.
Bug fixes
JOB_CREATED
) are automatically handledNew integrations have arrived
Integration updates and bug fixes
campaign_budget
and invoices
TooManyFilesError
org
parameter rather than full domain
ListView
data in memory during executioninvoices
department
and location
fieldsdepartment
and location
fieldsinventory_level
Stay tuned for more updates next time 🍻
Dec 3rd 2021
Happy Friday hotgluers! Here are the updates:
Added ability to run multiple target jobs for one user concurrently! 🚀
New integrations have arrived
tasks
directly to Salesforce!products
directly to WooCommerce!Integration updates and bug fixes
Stay tuned for more updates next time 🍻
Nov 19th 2021
Happy Friday hotgluers! Here are the updates:
Added automatic validation of tokens for API-based sources in the widget. Beta support is now available for Mailshake and ActiveCampaign 🚀
New version of hotglue-elements (0.0.15
) with support for target flows
Added new widget options:
HotGlue.link
Updated the demo on our landing page!
New integrations have arrived
Integration updates and bug fixes
Added new listeners to the widget
onTargetUnlinked
onWidgetOpen
Stay tuned for more updates next time 🍻
Nov 5th 2021
Happy Friday hotgluers! Here are the updates:
Revamped job logs view, designed to handle longer job logs 🎉
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 🍻
Oct 22nd 2021
Happy Friday hotgluers! Here are the updates:
state.json
of sources via APIARINVOICE
, ARADJUSTMENT
, CUSTOMER
, and ITEM
education
, lifetime giving
, and fundraiser assignment
Stay tuned for more updates next time 🍻
Oct 1st 2021
Happy Friday hotgluers! Here are the updates:
Added support for tap Mixpaneland SFTP 🎉 – docs coming soon 📖
Added support for targetMySQL
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 🚀
Connections
componentStay tuned for more updates next time 🍻
Sep 15th 2021
Happy Wednesday hotgluers! Here are this week's updates:
currency_code
Stay tuned for more updates next week 🍻
Aug 6th 2021
Happy Friday hotgluers! Here are this week's updates:
Added support for tap Mailchimp and PagerDuty 🎉 – docs coming soon 📖
Fixed issues when loading JupyterLab workspace from hotglue panel
hotglue widget now validates that required fields for API sources are filled (such as tap NetSuite and Chargebe)
Fixed bug on target Intacct that caused issues when a Currency
was passed to a Journal entry
Fixed bug that allowed users to open errored environments
Updated field map interface to use the catalog for the selected tenant
hotglue-elements
version
0.0.13
released 🚀
styleOverrides
directly to the Connections
componentStay tuned for more updates next week 🍻
Jul 28th 2021
Hey hotgluers! We've been super busy over the last few weeks, and we're excited to share our updates!
Recipes 👩🍳
Many users have benefited from having a starting point when creating a new integration. To that end, we're excited to announce a brand new recipes feature!
When you head into the settings page for certain sources, you'll find a new recipes section which allows you to use one of our prebuilt configurations. Currently, recipes include pulling contacts and contact lists from CRMs like Salesforce, and pulling tickets/issues from systems like Asana and GitHub.
You can check out a short demo of this feature below!
Outside of that, here are all the updates:
HackerNews launch with open sign up
Recipes for CRMs (Salesforce, HubSpot) and Issue Systems (GitHub, GitLab), with more coming! 👩🍳
Major UX overhaul including:
Updated field map interface with performance improvements and emphasis on search
Sources page is now segmented into specific categories, and has many performance improvements
Added support for tap GitHub and ActiveCampaign 🎉 – with many more integrations on the way
Bug fixes on target Xero
Updated onboarding process for new users
Stay tuned for more updates next week! 🍻
Jul 9th 2021
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 IDfor 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 🚀
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 🍻
Jul 2nd 2021
Happy Friday hotgluers! 🚀
This week we've got a few updates to share:
preload
option in hotglue widgetStay tuned for more updates coming in the next few weeks! 🍻
Jun 25th 2021
Happy Friday hotgluers!
I'd love to share some improvements made over the last week:
client_secret
configuration for a source)hotglue-elements
on some browsers where the React element didn't wait for the hotglue widget to be present in the DOM before mountingproject_id
metadata in each substreamJun 15th 2021
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:
API
sourcescompanies_properties
catalog.json
, fieldMap.json
)Stay tuned for more updates soon! 🚀