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 🍻

Multi-factor Auth, Facebook Ads, and more!

Happy Friday hotgluers! Here are the updates:

MFA Settings

  • 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-storage bug fixed regarding local clone path
    • tap-omnisend schema issues resolved
    • tap-klaviyo now supports API key validation
    • tap-iterable now uses correct start_date formatting for querying users data
    • tap-chargebee now 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 🍻

Bug fixes, JIRA source, and HubSpot + SFTP targets

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-sftp now supports delete_after_sync option which automatically purges files from remote server after sync is completed
    • tap-shopify now supports pulling shop data and orders in transit
    • target-netsuiteupdates:
      • bug with retry warning causing errors in job fixed
      • support for manually passing subsidiary field
      • remove case sensitivity for posting type
    • target-intacct issues with case sensitive posting type and rounding errors fixed
    • target-shopify now supports updating inventory_level

Stay tuned for more updates next time 🍻

Introducing team members! 🚀

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
    • 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-googleads has been updated to support campaign_budget and invoices
    • tap-sftp has been updated to parallelize processing of files and fixed hitting TooManyFilesError
    • tap-dynamics has been updated to allow deselecting fields and use org parameter rather than full domain
    • tap-salesforce now 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-netsuite now 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 🍻

Widget updates, new integrations, and bug fixes!

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-storage now supports parallelization even with smaller payloads to improve performance, and the log level has been fixed to avoid debug spam in job logs 🎉
    • target-ispolitical has been updated to support pushing payouts and refunds, and ISO 8601 date formats in payloads
    • tap-mixpanel has had several bug fixes to improve sync speeds and handle edge cases with malformed cohort members
    • tap-klaviyo patch to avoid throwing an error during discover step
    • tap-netsuite has been updated to support pulling inventory management data (SalesOrders, InventoryItems, PriceLevel, and more!)
    • target-intacct has been updated to support pushing department and location data with journal entries
    • target-shopify now supports pushing product variants and inventory quantities
  • Added new listeners to the widget
    • onTargetUnlinked
    • onWidgetOpen

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 🍻

Revamped sidebar, new taps + bug fixes

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

  • New Sidebar
    Improved 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 🍻 

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

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

New taps + bug fixes

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