Move Custom Objects from the Sandbox to Production

[NGermay]

We built several complex custom objects in our Sandbox environment. We are getting ready to load data into our production environment and need to copy the custom objects. One option is to do it by hand within HubSpot, which will take a long time and is prone to errors.

Is there a quick/easy way to export the Custom Objects and Properties we have added to the Contact Object from our sandbox to production environments? I found API requests to pull the data for the Custom Objects, but it doesn't look like I can use that export to directly import into the production environment.

[Mike_Eastwood · Accepted solution]

Hi @NGermay 

We start by creating the Objects in Postman because we work from Dev to Staging to Production. When we start in Postman we just tweak the Objects as we learn.

You can pull the Objects using the API, then push them into another HubSpot Portal, you'll need to clean out everything except the bare minimum of properties to avoid clashes. 

And, I would set up a test portal to test your API work – you can't rename Objects if you make a mistake (you have to delete them and add them again).

Have fun

Mike

[KMurota · Accepted solution]

@NGermay 

As @Mike_Eastwood suggests we can pull and create custom objects and their properties.

Here is the reference to the api. 

Make.com is my go-to tool for such a complex flow but when I don't want to spend too much time on it.

It replaced my 80〜90% of automation development from code to the platform.

Perhaps it is easier to use HTTP module and private token rather than the builtin hubspot module.

You can use the token on your sandbox to GET the objects and then one on the production to create them.

[Mike_Eastwood · Accepted solution]

Hi @NGermay 

We start by creating the Objects in Postman because we work from Dev to Staging to Production. When we start in Postman we just tweak the Objects as we learn.

You can pull the Objects using the API, then push them into another HubSpot Portal, you'll need to clean out everything except the bare minimum of properties to avoid clashes. 

And, I would set up a test portal to test your API work – you can't rename Objects if you make a mistake (you have to delete them and add them again).

Have fun

Mike

[NGermay]

Thanks for the pointing me in the right direction. We created the Objects in our sandbox using Postman with only a few properties and then added most of the properies directly in HubSpot.

I ended up pulling all the schema of the objects using the API, removed all the native HubSpot properties and created the new Object in our Production environment using my modified schema. It seemed to work well and didn't take too much time.

[Jaycee_Lewis]

Thanks for sharing your expertise, @Mike_Eastwood 🙌

[Jaycee_Lewis]

Hi, @NGermay 👋 Thanks for reaching out. Let's see if our community has any thoughts or approaches outside what you've already found.

Hey, @Mike_Eastwood @KMurota @weiliang_lee have you tackled this type of work before? Do you have any thoughts on approaches outside using the API to export the schema and records? 

Thank you! — Jaycee