topic Re: Problem: Update Property with Custom Code (Python) in APIs & Integrations

Problem: Update Property with Custom Code (Python)

henryt1 — Tue, 27 Jun 2023 07:53:58 GMT

Hallo Everyone,

thanks for having a look on my problem.

My goal: I have a date property and want to increase that date on one day with the help of custom code.

For example: Datefield is 10/08/2023 before the Code and after running the code it's 10/09/2023 (+ 1 day)

The Code works correctly and gives me the right output.

Problem: I dont get it to update the property ('contract_start_date') within the Deal. When I enroll the workflow, the property stays untouched.

My Workflow looks like this:

What am I doing wrong?

Huge thanks in advance for your help!

Update: I get this Workflow error, so maybe something with the code / correct date format is wrong?

The Code looks like this:

import os from hubspot import HubSpot from hubspot.crm.contacts import ApiException from datetime import datetime, timedelta def main(event): # Use inputs to get data from any action in your workflow and use it in your code instead of having to use the HubSpot API. contract_start_date = event.get("inputFields").get("contract_start_date") # Convert timestamp to a datetime-object contract_start_date = datetime.fromtimestamp(int(contract_start_date) / 1000) # add 1 day to the current date new_date = contract_start_date + timedelta(days=1) # convert to the right format (MM/DD/YYYY) new_date_formatted = new_date.strftime('%m/%d/%Y') # Set new date as the value of the date-property event['inputFields']['contract_start_date'] = new_date_formatted return { "outputFields": { "contract_start_date": new_date_formatted # Hier verwenden wir den formatierten String } }

Re: Problem: Update Property with Custom Code (Python)

himanshurauthan — Tue, 27 Jun 2023 08:32:00 GMT

Hello @henryt1

change the code to update the outputFields object instead of the inputFields object. Here is the updated code.

import os from hubspot import HubSpot from hubspot.crm.contacts import ApiException from datetime import datetime, timedelta def main(event): # Use inputs to get data from any action in your workflow and use it in your code instead of having to use the HubSpot API. contract_start_date = event.get("inputFields").get("contract_start_date") # Convert timestamp to a datetime-object contract_start_date = datetime.fromtimestamp(int(contract_start_date) / 1000) # add 1 day to the current date new_date = contract_start_date + timedelta(days=1) # convert to the right format (MM/DD/YYYY) new_date_formatted = new_date.strftime('%m/%d/%Y') # Set new date as the value of the date-property event['outputFields']['contract_start_date'] = new_date_formatted return { "outputFields": { "contract_start_date": new_date_formatted # Hier verwenden wir den formatierten String } }

After updating the code, you should be able to successfully update the contract_start_date property in the deal.

Re: Problem: Update Property with Custom Code (Python)

henryt1 — Tue, 27 Jun 2023 09:26:51 GMT

Hello Himanshu,

thank you really much for your quick answer! When I update the code, it gives me this error:

Is there somethin I could do?

Re: Problem: Update Property with Custom Code (Python)

henryt1 — Tue, 27 Jun 2023 10:57:01 GMT

I found the solution: the date-output from my code wasn't formatted correctly:
It needed to be in this way: UTC midnight aligned unix millisecond timestamps (ex: May 16 2022 would be 1652659200000)

Here's my updated Code:

import os from hubspot import HubSpot from hubspot.crm.contacts import ApiException from datetime import datetime, timedelta def main(event): # Verwende die Eingaben, um Daten aus einer Aktion in deinem Workflow zu erhalten und im Code zu verwenden, anstatt die HubSpot API verwenden zu müssen. contract_start_date = event.get("inputFields").get("contract_start_date") # Konvertiere den Zeitstempel in ein datetime-Objekt contract_start_date = datetime.fromtimestamp(int(contract_start_date) / 1000).date() # Addiere 1 Tag zum aktuellen Datum new_date = contract_start_date + timedelta(days=1) # Konvertiere das neue Datum zurück in das erforderliche Format (UTC midnight aligned Unix millisecond timestamp) new_date_formatted = int(new_date.strftime('%s')) * 1000 # Setze das neue Datum als Wert des Datum-Properties event['inputFields']['contract_start_date'] = new_date_formatted return {