Good Day everyone ! I am looking for some help in Netsuite Customer Deposit integration with Hubspot. Would appreciate if anyone could give any directions : Background/Issue : We are currently grappling with an integration challenge related to syncing Customer Deposits from HubSpot to NetSuite using Tray.io where Hubspot Object is not syncing to CustomerDeposit record in Netsuite. In HubSpot, we have established a Custom Object named "PaymentsReceived," which is linked to an existing Contact Object and a Deal Object in Hubspot. It's essential that the corresponding Contact (Customer in NetSuite) and Deal (SalesOrder in NetSuite) already exist in NetSuite. Goal : To trigger the Tray.io call, we've set up a webhook based on a Boolean property in the PaymentsReceived object. The expectation is that creating the PaymentsReceived custom object will activate the webhook in the Tray.io Workflow and synchronize the Payments Received record(Either create a new cord or update existing one) with the Customer Deposits record in NetSuite. A salesorder/Deal can have multiple PaymentsReceived/Customer Deposits instances attached to it. Steps taken : We are encountering an issue in creating/updating the record in NetSuite. Although we can retrieve the Customer Deposit from NetSuite using a combination of NetSuite connectors, HTTP connectors, and NetSuite SQLLite tools, the update query requires a mandatory property called "customer" which always returns invalid value whatever value is passed. We tried mapping this property to customer ID/Name/tranID, none of them seems to work. We also tried looking at the Netsuite schema and mapping the fields for "customer" from Customer Deposit there but those did not work either.

it should be the internal id of a customer, though you probably want to make sure that the internal id of the request is the value you expect it to be

Thanks a lot for your direction. By any chance do you know the fieldname of the internal id when retrieving the customer deposit record?

you are probably asking the wrong question because you dont know how select fields are represented