hotglue melt: October 2022

Oct 17th 2022

Hi hotgluers!

Welcome to our monthly hotglue melt - we have got some awesome updates to share!

Product Updates 🚀

Real-time Job Triggers ⚡

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.

hotglue salesforce triggers

We are rapidly expanding support based on demand – let us know if there are any you are interested in!

Mapping in the Widget 🔌

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!

hotglue widget mapping

Detailed Job Metrics 📊

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:

sync job metrics

New integrations ⚙️

hgmelt-october-2022-new-integrations.png

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

See the full list →

New features and improvements 🔨

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!

    • Also updated footer to include more categories from our integrations library
  • 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

    • Job failure alerts will now include summary error messages to provide more information
  • 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

Next up 📈

Here are some things to look forward to in the next updates:

  • Option to use Unified Schemas directly inside hotglue
  • Ability to connect multiple accounts from the same integration (for example, allow tenants to connect multiple Shopify stores in the widget)
  • Support for OAuth 1 integrations

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! 👋


hotglue melt: September 2022

Sep 1st 2022

Hi hotgluers!

Welcome to our monthly hotglue melt - we have got some awesome updates to share!

Product Updates 🚀

New Scheduler Service 🗓️

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.

New integrations ⚙️

hgmelt-september-2022-new-integrations.png

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

See the full list →

New features and improvements 🔨

Outside of our awesome redesign, the team made several improvements including:

  • Updated billing functionality

    • You can now view your active tenant usage and manage your hotglue subscription from directly within your Account Settings!
    • Automatic warning alerts will be emailed to your hotglue org members as you reach active tenant limits
  • Download Job service has been updated to allow you to download cached data from larger jobs (up to 20GB)

  • hotglue widget updates

    • Added support for localization
    • Added new option to hide back buttons when using HotGlue.link function
    • Added flag to allow tenants to link multiple sources in a single flow
    • Fixed bugs in scheduling UI
  • Added 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:

    • While refreshing, the field map will be inaccessible and show that it is being refreshed in the backend
    • Added visibility into logs of the refresh field map process (we call this a discover) in case of issues
  • General bug fixes and stability improvements

    • We suffered a major AWS outage in our region (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.

Next up 📈

Here are some things to look forward to in the next updates:

  • Mapping in the widget
  • Real-time triggers for sync jobs
  • Job Metrics for both past & running jobs

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! 👋


hotglue melt: July 2022

Aug 1st 2022

Hi hotgluers!

Welcome to our sixth hotglue melt - we have got some awesome updates to share!

Product Updates 🚀

Updated Landing Pages 🎨

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:

hotglue.com_.png

Updated integrations ⚙️

image (12).png

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.

See the full list →

New features and improvements 🔨

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 a hideFlows option to hide flow containers in the Connections component
    • Added class names to customize styling on the Connections component
    • Updated text under Quick Actions section in widget
    • Fixed compatibility issues with NextJS
    • Fixed bugs with unlinking connected integrations
  • 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

    • Fixed issue with flow icons being expired/disappearing
    • Added error message to explain when OAuth window pop-up is blocked
    • Improved error message detection logic in jobs

Next up 📈

Here are some things to look forward to in the next updates:

  • Mapping in the widget
  • Real-time triggers for sync jobs
  • Job Metrics for both past & running jobs

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! 👋


hotglue melt: June 2022

Jul 1st 2022

Hi hotgluers!

Welcome to our fifth hotglue melt - we have got some awesome updates to share!

Our Team 🤝

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.

Product Updates 🚀

React component + npm package 🎨

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:

d7ce86d-qa.hotglue.xyz_env_demo.env.hotglue.xyz_content_home.png

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.

Revamped Google Sheets integration 🤩

qa.hotglue.xyz_env_dummy.hotglue.hotglue.io_content_home.png

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

New integrations ⚙️

image (4).png

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.

See the full list →

New features and improvements 🔨

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:

    • Cleaned up the logging of exceptions in failing jobs to make them more readable
    • Added a section in admin panel to see a summarized log of why a job failed
    • Added an error field to the job details returned from the API including the summary log of why the job failed
  • Added the option to enable a Job History tab in the widget, so tenants have visibility into the sync jobs that have run. See below:

    qa.hotglue.xyz_env_dev.xyz.com_content_settings_tab=widget.png

  • 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

Next up 📈

Here are some things to look forward to in the next updates:

  • Unified schemas
  • Mapping in the widget
  • 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! 👋


hotglue melt: May 2022

Jun 1st 2022

Hi hotgluers!

Welcome to our fourth hotglue melt - we have got some awesome updates to share!

Our Team 🤝

hotglue team meetup - Sao Paulo Brazil

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.

Product Updates 🚀

Redesigned Widget 🤩

hotglue widget v2 preview

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

New integrations ⚙️

hotglue - May new integrations

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!

See the full list →

New features and improvements 🔨

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:

    Screen Shot 2022-06-09 at 11.35.04 AM.png

  • 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 :)

Next up 📈

Here are some things to look forward to in the next updates:

  • Improvements to our embeddable UI

    • Ability to install widget via npm
    • Updated React component with better performance and customizability
  • 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! 👋


hotglue melt: April 2022

May 1st 2022

Hi hotgluers!

Welcome to our third hotglue melt - we have got some awesome updates for you all.

Product 🚀

Redesigned UI 🤩

dashboard.png

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!

New integrations ⚙️

April new integrations

In April, our integrations team added a whopping 27 new integrations! The most notable are:

  • RingCentral
  • Freshcaller
  • Snowflake
  • Outreach
  • Zuora
  • Amplitude
  • Intercom
  • BigCommerce
  • Shipbob
  • Fulfil.io
  • Ordoro
  • Ecwid
  • Exact Online
  • NetoHQ
  • Vilkas
  • Wannafind
  • Dear Systems
  • Abicart

See the full list →

Bug fixes and improvements 🔨

Outside of our awesome redesign, the team made several improvements including:

  • Overall API performance improvements
  • Added endpoint and option in admin panel to force kill jobs. See the docs.
  • Added option to save snapshots even if jobs fail
  • Improved job queue times (now they start faster!)

Next up 📈

Here are some things to look forward to in the next updates:

  • hotglue widget v2
  • 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! 👋


hotglue melt: March 2022

Apr 25th 2022

Hi hotgluers!

Welcome to our second hotglue melt - we have got some awesome updates for you all.

Security 🔒

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.

Read more →

Product 🚀

New integrations ⚙️

s19o.png

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.

Read more →

New features and improvements 🔨

The product team did some amazing work during March. Here is what they did:

  • Created new daily tenant report to see failing jobs by tenant (you can enable in your settings)
  • Added option to enable error notifications for all failing jobs (used to just be for scheduled jobs)
  • Added option to automatically rollback failed jobs
  • Jupyter workspace will now notify you when it becomes inactive (instead of a silent shutdown)

Next up 📈

Here are some things to look forward to in the next updates:

  • A brand new look for hotglue 👀
  • 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! 👋


🛠️ Fix
👍 Improvement
🔥 Feature
💡 Integration

February Update - new integrations, CLI, and more!

Mar 1st 2022

Hey hotgluers! Here are the updates:

59fdf0af1b73054ffca6e6c510f85c26

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 🍻


🛠️ Fix
🔥 Feature
💡 Integration

Multi-factor Auth, Facebook Ads, and more!

Jan 14th 2022

Happy Friday hotgluers! Here are the updates:

c3566b67c52061290a8b3e3a31fa2a72

  • 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

    • Bootstrap error in browser console resolved
    • Prevent invalid widget preferences from being saved
    • GET /tenants endpoint timeout issue resolved and performance improved
    • Updated widget to call onTargetLinked correctly – was causing issues in hotglue-elements
  • New integrations have arrived 🎉

    • tap-facebook – currently supports pulling data from Facebook Ads
    • tap-amazon-advertising
    • tap-mailgun
    • tap-appsflyer
  • Integration updates and bug fixes

    • tap-cloud-storagebug fixed regarding local clone path
    • tap-omnisendschema issues resolved
    • tap-klaviyonow supports API key validation
    • tap-iterablenow uses correct start_date formatting for querying users data
    • tap-chargebeenow supports pulling exchange_rate from credit notes
    • target-netsuite now supports including customer in journal entries
    • target-shopify now supports incrementing inventory_level
    • target-hubspot now supports pushing contacts data

Stay tuned for more updates next time 🍻


🛠️ Fix
🔥 Feature
💡 Integration

Bug fixes, JIRA source, and HubSpot + SFTP targets

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

    • Issues when adding/editing supported targets in hotglue panel fixed
    • Prevent invalid state.json files from being used by future jobs (discovered with tap-klaviyo)
  • New integrations have arrived

    • target-hubspot – currently supports pushing engagements and contacts to HubSpot
    • target-sftp
    • tap-jira
  • Integration updates and bug fixes

    • tap-netsuite

      bug fixes:

      • Item rate schema fixed
      • handle malformed search results (ignore malformed pages)
      • empty data error resolved
    • tap-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:

      • bug with retry warning causing errors in job fixed
      • support for manually passing subsidiary field
      • remove case sensitivity for posting type
    • target-intacctissues with case sensitive posting type and rounding errors fixed

    • target-shopifynow supports updating inventory_level

Stay tuned for more updates next time 🍻


Introducing team members! 🚀

Dec 17th 2021

Happy Friday hotgluers! Here are the updates:

122f6e70a9cb52f51c7b59311f3a68cc

  • 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

    • Stalled jobs (stuck in JOB_CREATED) are automatically handled
    • Toggle sync schedule endpoint timeout issue fixed
    • Failing scheduled job alert has been re-enabled
  • New integrations have arrived

    • tap-recurly
    • tap-omnisend
  • Integration updates and bug fixes

    • tap-googleadshas been updated to support campaign_budget and invoices
    • tap-sftphas been updated to parallelize processing of files and fixed hitting TooManyFilesError
    • tap-dynamicshas been updated to allow deselecting fields and use org parameter rather than full domain
    • tap-salesforcenow avoids holding ListView data in memory during execution
    • target-salesforce now supports pushing any objects (including custom data), and allows for updating objects using an external ID
    • target-quickbooks now supports pushing invoices
    • target-queue-storage bug fixed causing issues with processing payloads with less than 512 entries
    • tap-procore now supports pulling Purchase Orders
    • tap-netsuitenow supports pulling Purchase Orders
    • target-xero now supports pushing Journal Entries with configurable department and location fields
    • target-netsuite now supports pushing Journal Entries with department and location fields
    • target-shopify now supports posting updates to inventory_level

Stay tuned for more updates next time 🍻


🛠️ Fix
👍 Improvement
💡 Integration

Sendinblue, Reviews.io, Iterable, and more!

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

    • 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-salesforcenow allows you to push tasks directly to Salesforce!
    • target-woocommercenow allows you to push products directly to WooCommerce!
  • Integration updates and bug fixes

    • target-queue-storagehas been updated to use multi-threading to handle larger payloads in less time 🎉
    • target-s3now supports using SSE and allows users to set an ACL option
    • tap-googleadshas been updated to use the new Google Ads API (instead of the older Adwords API, which has been deprecated by Google)
    • tap-netsuitehas been updated to include internalId in payloads
    • tap-sftphas been updated to automatically detect encoding to support non UTF-8 encoded CSV files
    • tap-mixpanelhas been updated with new error handling to catch unexpected responses from Mixpanel's API

Stay tuned for more updates next time 🍻


🛠️ Fix
🔥 Feature
💡 Integration

Widget updates, new integrations, and bug fixes!

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:

    • setting to disable breadcrumbs in widget
    • ability to specify helper text in markdown when using HotGlue.link
  • Updated the demo on our landing page!

  • New integrations have arrived

    • tap-clickup
    • tap-klaviyo
    • tap-dynamics
    • target-google-sheets
    • target-netsuite
  • Integration updates and bug fixes

    • target-queue-storagenow supports parallelization even with smaller payloads to improve performance, and the log level has been fixed to avoid debug spam in job logs 🎉
    • target-ispoliticalhas been updated to support pushing payouts and refunds, and ISO 8601 date formats in payloads
    • tap-mixpanelhas had several bug fixes to improve sync speeds and handle edge cases with malformed cohort members
    • tap-klaviyopatch****to avoid throwing an error during discover step
    • tap-netsuitehas been updated to support pulling inventory management data (SalesOrders, InventoryItems, PriceLevel, and more!)
    • target-intaccthas been updated to support pushing department and location data with journal entries
    • target-shopifynow supports pushing product variants and inventory quantities
  • Added new listeners to the widget

    • onTargetUnlinked
    • onWidgetOpen

Stay tuned for more updates next time 🍻


🛠️ Fix
👍 Improvement
🔥 Feature
💡 Integration

Job Logs Revamp, Shopify target, and bug fixes

Nov 5th 2021

Happy Friday hotgluers! Here are the updates:

995e4b3f52ae2c5b6eed5c7eab995d50

  • 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 🍻


👍 Improvement
💡 Integration

Shopify OAuth, ISPolitical, and expanded coverage

Oct 22nd 2021

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 🍻


🛠️ Fix
👍 Improvement
💡 Integration

Mixpanel, SFTP, and MySQL support + bug fixes

Oct 1st 2021

Happy Friday hotgluers! Here are the updates:

91daf24a839a4299f0a19b51bf52aadc

  • 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 🚀

    • Improved load time on first open of Connections component

Stay tuned for more updates next time 🍻


🛠️ Fix
🔥 Feature
💡 Integration

Revamped sidebar, new taps + bug fixes

Sep 15th 2021

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

  • https://img.announcekit.app/ae0ff021d7b40c9ef46135c107ab756a?s=8f4fa638275caa085065f0da8d6c8f0fImproved sidebar with better navigation + performance (plus, it looks better 👀)
  • Added support for tap Airtable, WooCommerce,****and Blackbaud 🎉
  • Fixed issues with saving field map for tenants
  • Fixed bug in target-csv causing issues with validating floats
  • Added support for OAuth sources that also need user configured params
  • Added endpoint to toggle schedules for all tenants in a given environment
  • Removed table name requirement for Airtable target
  • Fixed errors causing schedule endpoint to fail
  • Bumped target Quickbooks version
  • Fixed bugs where Source page would overflow on smaller browser sizes
  • Bumped tap Chargebee version to support pulling currency_code
  • Switched to use the Data Mill Singer PostgreSQL target to handle creation of tables + columns automatically

Stay tuned for more updates next week 🍻


🛠️ Fix
💡 Integration

Mailchimp & PagerDuty support + bug fixes

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 🚀

    • Fixed bug where clicking linked source would cause infinite loading until page refresh
    • Added ability to supply styleOverrides directly to the Connections component

Stay tuned for more updates next week 🍻


💡 Integration
🔥 Feature
💡 Integration

Recipes, UX updates, new sources, and more! 🚀

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

      • Catalog of available objects from each source, now allows you to browse the entire selection directly from hotglue!
      • Field editor on each object is now searchable and easier to navigate
    • 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! 🍻


🛠️ Fix
👍 Improvement
💡 Integration

Airtable, Google Sheets support + misc bug fixes

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 🚀

    • 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 🍻


🛠️ Fix
👍 Improvement
💡 Integration

BigQuery support, bug fixes, and improvements

Jul 2nd 2021

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! 🍻


🛠️ Fix
🔥 Feature

New taps + bug fixes

Jun 25th 2021

Happy Friday hotgluers!

I'd love to share some improvements made over the last week:

  • Support for secret API key that has permission to retrieve secret data (like client_secret configuration for a source)
  • Fixed issue with hotglue-elements on some browsers where the React element didn't wait for the hotglue widget to be present in the DOM before mounting
  • Fixed bug with JupyterLab workspaces allowing users to connect before they had booted
  • Fixed bug requiring users to refresh to see new sources in a flow in the new job dialog
  • Fixed bug with launching new jobs for tenants via the dialog
  • Fixed bug loading configured flow targets that showed the list of all targets first
  • Both tap NetSuite and tap Pipedrive are out of beta! 🎉
  • Added support for tap GitLab
  • Procore tap has been updated to include project_id metadata in each substream


👍 Improvement

General improvements

Jun 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:

  • 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! 🚀