topic Re: Issue with my code not writing data back to a Deal with the updated value in APIs & Integrations

Issue with my code not writing data back to a Deal with the updated value

RReiffer — Mon, 10 Jul 2023 19:03:57 GMT

All,

I am trying to do the following in Deals. If the amount is null or = 0 then replace the amount with the Total Contract Value (hs_tcv). My flow appears to do everything, no errors but the amount field stays blank. Below is the code and a screen shot of my input and output variables.

const hubspot = require('@hubspot/api-client');

exports.main = async (event, callback) => {

const hubspotClient = new hubspot.Client({

accessToken: "pat-na1-NOPE"

});

//console.log("Made it past OAuth")

//First, make a call to get deal associations

var amount = event.inputFields['amount'];

//console.log(amount)

var hs_mrr = Number(event.inputFields['hs_mrr']);

var hs_tcv = event.inputFields['hs_tcv'];

//const closedate = event.inputFields['closedate'];

//console.log(hs_tcv)

//console.log("1",amount)

var amount_new = amount

if(amount_new > 0) {var amount_new = amount} else {var amount_new = hs_tcv}

//console.log("2",amount_new)

amount = amount_new

//console.log("3", amount)

callback({

outputFields: {

amount: amount

}

});

}

Re: Issue with my code not writing data back to a Deal with the updated value

RReiffer — Tue, 20 Jun 2023 17:43:38 GMT

Hi @Teun, @louischausse, @johnelmer - here is the code I was referring to. Thanks

Re: Issue with my code not writing data back to a Deal with the updated value

RReiffer — Tue, 20 Jun 2023 18:07:43 GMT

Hey everyone, I finally figured it out (duh). I needed to add a step in the workflow that actually copies that value BACK to the deal from the custom code. I assumed that the code actually wrote data back but it only writes data back to the custom code workflow object.

Re: Issue with my code not writing data back to a Deal with the updated value

KimM — Fri, 30 Jun 2023 09:56:48 GMT

Hey @RReiffer , Glad to see you found a solution to this.

I did notice that in your initial post you've used what looks like your access token. Just wanted to make sure that you changed this as otherwise people can access your Hubspot data via API with this.

Happy Hubspotting!

Re: Issue with my code not writing data back to a Deal with the updated value

Jaycee_Lewis — Mon, 10 Jul 2023 19:05:30 GMT

Good catch, @KimM 🙌 I went ahead and edited it out of the original post. And, @RReiffer should definitely rotate that key if they haven't already. — Jaycee

Re: Issue with my code not writing data back to a Deal with the updated value

HubDoPete — Sun, 20 Aug 2023 10:21:58 GMT

Hi Richard, I'm curious why you wrote custom code for this.

If your Deal workflow:

triggers on MRR property is 'known', and permits deal re-enrollment
then copies the Deal MRR property to Deal Amount
will that also suffice?

best

Pete

Re: Issue with my code not writing data back to a Deal with the updated value

RReiffer — Mon, 21 Aug 2023 12:22:37 GMT

Pete,

Wew wanted to have Total Contract Value and not MRR.

Rich

Re: Issue with my code not writing data back to a Deal with the updated value

RReiffer — Mon, 21 Aug 2023 12:23:08 GMT

Done! Thanks

Re: Issue with my code not writing data back to a Deal with the updated value

HubDoPete — Mon, 21 Aug 2023 12:29:57 GMT

Hi Richard, in that case, could you just copy across the Deal TCV?

workflow triggers on TCV property is 'known', and permits deal re-enrollment
then copies the Deal TCV property to Deal Amount

That property is also automatically updated by HubSpot per deal. If you need custom code then sure thing - I was just curious as there are four calculated fields on each deal that you can copy to deal amount:

Total contract value (TCV),
Annual contract value (ACV),
Annual recurring revenue (ARR)
and Monthly recurring revenue (MRR).

We ended up writing a help page on automating deal value because it comes up regularly for apps like DoPricer which change line item prices and discounts in the background via the API. So the workflow keeps the deal amount accurate.

best

Pete