https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/901055#M2003 <P>I have some experience in R but nearly none in JavaScript/Python. In scowering the internet for hours this is the best I've came up with with finding line item associations with a deal. I want to be able to use the line items and their information later in the workflow to attach to a new deal.<BR /><BR /></P><P>What am I missing?</P><LI-CODE lang="javascript">const hubspot = require('@hubspot/api-client'); exports.main = (event, callback) =&gt; { const hubspotClient = new hubspot.Client({ apiKey: process.env.hapikey }); // First, make a call to get deal associations hubspotClient.crm.deals.associationsApi.getAll(event.object.objectId, 'line_item').then((results) =&gt; { let lineItemPromises = results.body.results.map(item =&gt; { // For each line item, get its details return hubspotClient.crm.lineItems.basicApi.getById(item.id, ['amount']).then(results =&gt; { return results.body; // Return the details of the line item }).catch(err =&gt; { console.error(`Error fetching details for line item ${item.id}:`, err.message); return null; // Return null or handle as appropriate for your needs }); }); // Resolve all promises to get details of each line item Promise.all(lineItemPromises).then(lineItemDetails =&gt; { console.log(lineItemDetails); // Log the details of all line items // Further processing can be done here with lineItemDetails // For example, filtering high-value line items, aggregating data, etc. callback({}); // Complete the function }).catch(err =&gt; { console.error('Error processing line items:', err.message); callback({}); // Complete the function, consider passing error details }); }).catch(err =&gt; { console.error('Error fetching line item associations:', err.message); callback({}); // Complete the function, consider passing error details }); }</LI-CODE><P>&nbsp;</P> Fri, 05 Jan 2024 00:28:49 GMT AOber 2024-01-05T00:28:49Z https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/901055#M2003 <P>I have some experience in R but nearly none in JavaScript/Python. In scowering the internet for hours this is the best I've came up with with finding line item associations with a deal. I want to be able to use the line items and their information later in the workflow to attach to a new deal.<BR /><BR /></P><P>What am I missing?</P><LI-CODE lang="javascript">const hubspot = require('@hubspot/api-client'); exports.main = (event, callback) =&gt; { const hubspotClient = new hubspot.Client({ apiKey: process.env.hapikey }); // First, make a call to get deal associations hubspotClient.crm.deals.associationsApi.getAll(event.object.objectId, 'line_item').then((results) =&gt; { let lineItemPromises = results.body.results.map(item =&gt; { // For each line item, get its details return hubspotClient.crm.lineItems.basicApi.getById(item.id, ['amount']).then(results =&gt; { return results.body; // Return the details of the line item }).catch(err =&gt; { console.error(`Error fetching details for line item ${item.id}:`, err.message); return null; // Return null or handle as appropriate for your needs }); }); // Resolve all promises to get details of each line item Promise.all(lineItemPromises).then(lineItemDetails =&gt; { console.log(lineItemDetails); // Log the details of all line items // Further processing can be done here with lineItemDetails // For example, filtering high-value line items, aggregating data, etc. callback({}); // Complete the function }).catch(err =&gt; { console.error('Error processing line items:', err.message); callback({}); // Complete the function, consider passing error details }); }).catch(err =&gt; { console.error('Error fetching line item associations:', err.message); callback({}); // Complete the function, consider passing error details }); }</LI-CODE><P>&nbsp;</P> Fri, 05 Jan 2024 00:28:49 GMT https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/901055#M2003 AOber 2024-01-05T00:28:49Z https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/902124#M2006 <P>Hi&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/687369">@AOber</a>&nbsp;and Happy New Year!!!<BR /><BR />Thank you for reaching out to the Community!<BR /><BR />For information, I'd like to share this documentation on the subject "<A href="https://developers.hubspot.com/docs/api/workflows/custom-code-actions" target="_blank" rel="noopener">Custom code workflow actions</A>".<BR /><BR />I understand that you are trying to find line item associations via a custom coded workflow action. If that's not the case, please let me know.<BR /><BR />I'll be glad to put you in touch with some of our Community Members and some of our Top Experts on this matter:<BR /><BR />Hi&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/583096">@AKoprivec3</a>,&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/539078">@MatthiasKunz</a>,&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/161963">@JStenbaek</a>,&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/20261">@louischausse</a>,&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/135859">@Sylg</a> and,&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/138846">@kierana</a> do you have suggestions to help&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/687369">@AOber</a>, please?<BR /><BR /><STRONG>Also, if anybody else has anything to add and/or share, please feel free to join in the conversation :</STRONG>)<BR /><BR />Thank you so much and have a fantastic day!<BR /><BR />Best,<BR />Bérangère</P> <P><LI-WRAPPER></LI-WRAPPER></P> Mon, 08 Jan 2024 09:53:47 GMT https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/902124#M2006 BérangèreL 2024-01-08T09:53:47Z https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/902126#M2007 <P>Hey&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/230185">@BérangèreL</a>&nbsp;&amp;&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/687369">@AOber</a>&nbsp; thanks for the mention (hopped on another acc),<BR /><BR />There a couple of potential issues I see here but I'd be great if I could see the error you're having when testing this.<BR /><BR />Also I'm guessing this is a deal based workflow since you're using the event's object objectId as the dealId correct?<BR /><BR />I don't like the associations API too much (its arguably better though) so I usualy use the Deal API if I'm trying to get associated Line Items from the deal and then batch read the IDs of the Line items to get their details.<BR /><BR />When I'll see you're error logs I might be able to help you better here.<BR /><BR />Best,<BR />Anze<BR /><BR /><BR /></P> Mon, 08 Jan 2024 10:01:49 GMT https://community.hubspot.com/t5/Data-Hub/Custom-Coded-Workflow-find-line-item-associations/m-p/902126#M2007 AnzeKoprivec 2024-01-08T10:01:49Z