We have a custom list where the abbreviation needs to be the internal id. Eg a line might be id=100 value=Widget abbrev=100 Does anyone know a good way to find the current highest internal id in the list? I couldn’t figure out how to run a saved search against a custom list - is that possible? Or is there a way of seeing the next id to be allocated? Strange question I know… We are using Celigo if there’s a way to do it, using that

I'm not sure I fully get the use case. Are you syncing this list with another system? I don't think you can make a saved search on custom lists, but here are a few other ideas. 1. Convert the list to a custom record. I've done this quite often since they have much more flexibility and then you can run a saved search. 2. Use a suitescript hook that Celigo calls to fetch the latest internal id. Within the script, you could use some suiteql or maybe some other query offering to get it and return the results to Celigo. https://docs.celigo.com/hc/en-us/articles/360050485392-SuiteScript-hooks-overview 3. You could create a custom connection to NetSuite within IO where you can run suiteql queries. With that you could easily do select max(id) from custom_list. Here are a few articles to help. a. https://docs.celigo.com/hc/en-us/articles/14349054963995-Set-up-an-OAuth-1-0-connection-to-NetSuite-SuiteTalk-APIs-including-SuiteQL- b. https://docs.celigo.com/hc/en-us/articles/14350808413339-Export-data-from-NetSuite-using-SuiteQL

with SuiteQL, it's as simple as

select * from customlist123

Celigo can support SuiteQL via the HTTP connector as simply as @Shawn Talbert described.

the celigo HTTP connector can do OAuth 1/2?

@Shawn Talbert yes

nice

Hi @Tyler Lamparter - thanks for the steer. I set up the SuiteQL connection and that worked great. Much appreciated.

@Shawn Talbert we support oauth 2 client credentials. Do you see otherwise?

Sorry, I should have clarified using X509 certs for authentication to take advantage of the built-in configuration UI for same in NetSuite. (as opposed to a client secret that is just a password)

@Shawn Talbert I haven't messed with certs much, but maybe this would work?

if that dialog is associated to the OAuth2 login then yes it may apply. Core SSL uses certs as well so this may be that? Note that I'm not an active user of Celigo, so I can't confirm or play around with specific screenshots. However, it seems Celigo has come a long way technically since I last look so now I'm interested again.

@Shawn Talbert yes this is SSL configuration on an oauth 2 connection that can be made to any endpoint. Can you point me to some NetSuite docs on this and I can play around because now I'm curious lol. Also, glad to hear you're thinking of us a bit more! Is this what I'm looking for? https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_162686838198.html

Yup, that's it. It's nice in that it doesn't require both sides to have a shared secret.