Mapping NetSuite Custom Fields

  • 38Views
  • Last Post 1 hour ago
0
votes
David Weninger posted this 2 weeks ago

How do I map custom fields from NetSuite to SQL? For example we have many custom fields on the NetSuite Customer. When I map the NetSuite Customer to SQL, I only see NetSuite fields.

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 2 weeks ago

Hi David!

Please open your NetSuite connection and select the 'Use Custom Tables' and 'Use Custom Fields' check boxes. More information is available here:

https://skyvia.com/resources/docs/index.html?netsuite_connections.htm

 

Please tell me if this helps.

 

Best regards,

Mariia

0
votes
David Weninger posted this 1 weeks ago

I have both options checked. I am not seeing the custom fields when I run the sync.

0
votes
Mariia Zaharova posted this 6 days ago

Hi David!

We checked metadata of your NetSuite connection and there are a lot of custom fields in the Customer table.

Please open your package, click Edit for Customer task and then click the Refresh button. Whether custom fields are available and checked? If not, please specify whether all custom fields are not available in the Task Editor or only some of them.

 

Looking forward to your reply.

0
votes
David Weninger posted this yesterday

I clicked Refresh on the Customer object in my NetSuite connection. I still do not see any custom fields. Can we have a WebEx tomorrow (Monday)? I need to get this working.

0
votes
Mariia Zaharova posted this yesterday

Hi David!

 

Please also try these steps:

 - open your NetSuite connection and click the 'clear' for "Metadata Cache" parameter;

- open your package and edit the Task; if fields are still not available, try clicking Refresh button again.

 

Looking forward to your reply.

0
votes
David Weninger posted this yesterday

Clear was not an option for Metadata Cache. I changed it to Disabled and Refreshed the customer table. Still not seeing custom fields.

0
votes
Mariia Zaharova posted this 1 hour ago

Please specify the names of the fields which you are expecting to see in your package.

 

Please note the following limitations: Skyvia does not support NetSuite fields, storing array data, and does not support custom NetSuite fields having double quotation marks in their name.

0
votes
David Weninger posted this 1 hour ago

Here are some examples:

Close