Bas van Ditzhuijzen Strategic Partner NetSuite Integration Whiz Salesforce Integration Whiz

1. Community
2. Troubleshoot custom flows
3. Help adding POs to vendor bills on NetSuite

Hi, you need to map the line fields orderdoc and orderline on the Bill record to link the bill to the purchase order. These are not exposed on the form in NetSuite so Celigo doesnt have a auto-sugg...

• View comment
• Bas van Ditzhuijzen
• March 08, 2023 09:10
• 0 votes

1. Community
2. Troubleshoot custom flows
3. Paginated data not being passed through remainder of flow

Hi Josh, a nice way to test if you pagination is working correctly is to set the pagesize to a low number, so in this case set "numProducts" to 2 on both query body's. Then click the preview button...

• View comment
• Bas van Ditzhuijzen
• February 23, 2023 14:22
• 0 votes

1. Create custom code
2. Custom settings and forms
3. Common form fields

There is an extra type "exportSelect" that allows you to do a virtual export, and choose one of the results for your custom setting: Make sure that your virtual export returns 'label' and 'value' ...

• View comment
• Bas van Ditzhuijzen
• February 17, 2023 08:52
• 0 votes

1. Create custom code
2. Custom settings and forms
3. Common form fields

There is an extra inputType "staticMap" that allows you to do make a mapping table based on data that is sourced live from the source&target systems. There is an excellent example by Tyler in the ...

• View comment
• Bas van Ditzhuijzen
• February 17, 2023 08:45
• 0 votes

1. Community
2. Troubleshoot custom flows
3. Branched flows cannot refresh access tokens

Hi Steve, My workaround is to not use any branching. My guess is that branched flows use a different codebase to decide which tile to pass the page of data to, and that when Celigo refreshes the to...

• View comment
• Bas van Ditzhuijzen
• February 17, 2023 08:35
• 0 votes

1. Community
2. Troubleshoot custom flows
3. Customize Virtual Export NSObject Response

Hi, The easiest way would be to set the custom field label in the NetSuite Saved Search to be the actual field name.

• View comment
• Bas van Ditzhuijzen
• February 15, 2023 19:13
• 0 votes

1. Community
2. Troubleshoot custom flows
3. What's with the blue dots??

It signals that a flow has a schedule/has a mapping set.

• View comment
• Bas van Ditzhuijzen
• January 23, 2023 07:52
• 1 vote

1. Community
2. Troubleshoot custom flows
3. Handling API property that can be Array or Object

You can do this by adding both cases in the visual export transformation: This works because if its an array only the top mapping will map, if its an object only the bottom one will be used. I've ...

• View comment
• Bas van Ditzhuijzen
• December 22, 2022 12:12
• Edited
• 0 votes

1. Community
2. Troubleshoot custom flows
3. Updating Netsuite Price

Although counter-intuitive, I would always update the price, even if it is the same as the previous one. There is no performance-gain to be had by doing an extra database query to look up the curre...

• View comment
• Bas van Ditzhuijzen
• December 15, 2022 16:22
• 1 vote

1. Community
2. Integrator.io enhancement requests
3. DevOps for scripts

You can PUT changes to the scripts endpoint using the same json format you get when you GET a specific script.

• View comment
• Bas van Ditzhuijzen
• December 14, 2022 08:48
• 0 votes