In Export, we fetched the saved search data from the NetSuite side. Sometimes we get this error while taking the preview of Export. We can solve this by making the saved search in the NetSuite as PUBLIC
Category: Celigo
Configure error notification emails for other users
If you have Manage access to an integration, you can set up notifications for other users. To set up subscriptions for a user: Navigate to the integration that contains the connections or flows for which you want to configure email notification. On the Users tab, examine the list of users and the icons that appear in the Notifications column. Click… Continue reading Configure error notification emails for other users
Solve the error: Failed to save record because You must enter at least one line item for this transaction
While we are using suiteAPP 2.0, it will throw an error when all the sublist(eg: items) values are hardcoded. we need to map either one of the sublist values from exports(Standard type) or you can use the dynamic lookup to solve the above error
Create a Standalone Tile
Click on the Create option on the Home page and select the Integration option from that. Then give a name for the Tile and Save this. Thus we have created a new standalone Tile with a name we required.
Get error notifications via email(you only)
To set up up your email subscriptions on the Notifications tab: Navigate to the integration that contains the flows or connections for which you want to configure email notification. Click the Notifications tab. Under Notify me on flow error, select All flows or specific flow(s). When you are finished selecting flows, click Done. Under Notify me when connection goes offline, select the… Continue reading Get error notifications via email(you only)
Handle white space
Whitespace placed before any symbol inside the handlebars will cause an error. Correct: {{expression}}{{dateFormat}} Incorrect: {{ expression}}{{ dateFormat}} // note the leading whitespace Error: {{expression {{field}} // second set of opening braces seen as new expression
Retrieve WooCommerce consumer key and consumer secret
Sign in to your WooCommerce account. Navigate to WooCommerce > Settings > API > Keys/Apps Click Add key. Add a description and select the WordPress user for which you want to generate the key. Choose the level of access for this REST API key. Access levels include Read access, Write access, or Read/Write access. Click Generate API key and WooCommerce will generate REST API keys for the selected user. Now that keys have… Continue reading Retrieve WooCommerce consumer key and consumer secret
Set up a manual token-based auth connection to NetSuite
NetSuite StepsA. Enable your NetSuite account with Token-Based Auth (TBA) Log into NetSuite as an Administrator. Go to Setup > Company > Enable Features. Click SuiteCloud subtab. Scroll down to Manage Authentication section. Check the TOKEN-BASED AUTHENTICATION checkbox. Save your changes. B. Create custom NetSuite Role Log into NetSuite as an Administrator. Go to Setup > Users/Roles > Manage Roles. Click Customize beside the Celigo integrator.io Full… Continue reading Set up a manual token-based auth connection to NetSuite
Error ‘Element value exceeds the fixed length of 30’
Error Message Element value “[STRING]” exceeds the fixed length of 30. Use the truncate property if you wish to allow this element value to be truncated. Solution To set the truncate property for CSV files, modify the FTP import configuration. Select Truncate last row delimiter and save the configuration.
Billing sync (NetSuite-Magento)
The Billing flow “NetSuite Billing to Magento Invoice Add” data flow exports Invoices from NetSuite to Magento. The data flow exports fully/partially billed orders in NetSuite as invoices in Magento. STEPS 1.Generate cash sale from Item Fulfillment in NetSuite. 2.Restrict the saved search criteria with ‘eTail Order Billing exported’ 3. Perform mapping in the flow… Continue reading Billing sync (NetSuite-Magento)