FAQ: Cannot sync record URL from NetSuite to Salesforce

[courtneyjordan]

Because the URL value does not exist in a field in NetSuite, our integration app does not provide mapping for it. There are two workarounds:

• You'll need to add a Type field in the Custom Entity Field in NetSuite, then select Hyperlink. In the Validation & Defaulting tab below, specify the Default Value with your URL and an ID such as below. Here are some NetSuite KBs that cover this:
  https://netsuite.custhelp.com/app/answers/detail/a_id/72917/kw/record%20hyperlink
  https://netsuite.custhelp.com/app/answers/detail/a_id/67746/kw/record%20hyperlink
  

• If you don't want to customize your NetSuite, you can add a mapping for NetSuite Record, then in the settings for that mapping, modify the Expression to your NetSuite URL.
  

[Amit_Vyas]

Yeah, this one confused us too the first time we tried syncing links from NetSuite to Salesforce using Celigo integrator.io.

At first we kept looking for a “record URL” field in NetSuite to map… but it just doesn’t exist, which is why Celigo can’t pick it up directly.

We ended up getting a bit of outside help, and the fix was actually pretty straightforward once explained.

What worked for us was:

• creating a custom field in NetSuite

• setting the type to Hyperlink

• and then using a formula/default value to build the URL using the internal ID

Something along these lines:

https://<account>.app.netsuite.com/app/common/entity/custjob.nl?id={internalid}

Once that field is there, you just map it normally in Celigo and it flows into Salesforce without any issues.

We did try the “expression in Celigo” route as well (building the URL using {{internalid}}), and it works… but honestly it felt a bit patchy. The custom field approach has been much cleaner for us, especially when you have multiple flows.

In case it helps, here Celigo NetSuite we referred to when we were figuring it out (they explained the approach pretty clearly):