Mine an API response stored on a record
A webhook writes raw JSON to a property; extract the fields you need with dot paths.
The challenge
A webhook writes a blob of JSON to a property, and the fields inside it cannot be reported on, segmented or used in later steps.
How AuPerate solves it
Transform and Map Data pulls the values out by dot path and writes them to real properties that HubSpot can use.
How to build it
- 1Have a Send Webhook step write the raw JSON response into a property.
- 2Add Transform and Map Data and choose Extract a value from JSON.
- 3Point the source at that property and give a dot path such as data.order.id.
- 4Write the extracted value to its own property so it is reportable.
What the action gives you
- Value mapping with one from = to pair per line
- Concatenate with a live property multiselect
- Split one property into several, remainder preserved
- Regex extraction with capture groups
Related
Other patterns teams build
Convert a private PDF link into a public URL
The system snippet calls the HubSpot Files API for a signed URL and returns it as an output you can email or send onward.
Call an internal API with a signed JWT
Store the signing key as a secret, build the JWT in code with crypto, and post with axios.
Sync a closed deal into your ERP
POST the deal payload to your ERP endpoint on stage change; map the returned order id back onto the deal.
Build this in your own workflows
Install AuPerate once and every action appears in your HubSpot workflow editor.
Get Started