Francesca Nicole Mendoza-Oracle Gold Crown

Hello @JWM FlightCheck, Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello @User_EQ8MF, I believe you will be able to use SuiteQL without additional licenses. But to verify, you can try to send the sample JSON from SuiteAnswers Using SuiteQL with SuiteTalk REST Web Services I hope this helps! If you find this reply to your question useful, others might as well. By clicking the “Yes” button…

Hello @FazeprooF, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support.

Hello @kees.netsuiteadmin, Good day. Upon checking, it is currently not possible to get the file/attachment records in ODBC/SuiteQL. It is currently filed under the enhancement: 134721 ODBC >Item/File Cabinet > Implement a support for binary format and introduce a new table for file cabinet items Attachments are usually…

A contact is a subrecord, therefore the format that should be followed would be in this documentation: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_156337267817.html#Working-with-Subrecords Subrecords are independent records linked by relationships and are a bit different from normal sublist…

Hi @User_EQ8MF, This is achievable with SuiteQL Queries, as it is the most flexible way to get data using REST API. You can choose certain fields and join tables to get the data that you need. Let me know if you need anything else! If you find this reply to your question useful, others might as well. By clicking the “Yes”…

Hello @GiCo74, Bumping this thread in case you missed my previous comment. Thanks!

Hi @RickG_1136, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated. 

Hello @User_FL4CK, Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Glad to hear that. Thank you for letting us know, Dawn! Have a good one.

Hello @Manish_Mohan, Bumping this thread in case you missed my previous comment. Thanks!

Hello @User_8X611, Were you able to check my previous comment?

Hello @Elizabeth Vance, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued.

Hello @GiCo74, This is achievable with SuiteScript but as of now, out of the box solutions only offer CSV, PDF, and Excel File Exports.

Hi @User_EQ8MF, I think there is a bit of misunderstanding. These enhancements mentioned in the previous comment were for Saved Searches but not NetSuite Reports. The only way to get data right now would still be using ODBC, REST API's SuiteQL Queries, or SOAP API's search function (which is capable of running a…

Hello @Frederick Mc, It is currently not within NetSuite's capabilities but it sounds like a good suggestion for future implementations. If you are interested, you can file this as a SuiteIdea so that our Product Managers can consider them in the future. Thanks!

Hi User_HKV76, Cool! If that's the case, you should create a new contact record and reference the vendor ID for the companyname field. To do this, you must use POST instead of PATCH, and use this URL format: {{REST_SERVICES}}/record/v1/contact Sample JSON: { "entityid":"Sample Contact 001", "company" : 213, "email":…

Hello @Manish_Mohan, You might want to consider using Dependent Dropdown Lists to be able to achieve this. Here is a link to the documentation if you would like to explore it: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2840468.html#Dependent-Dropdown-Lists I hope this helps! If you find this…

Helllo @Dext3r, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated. 

Hello @User_EQ8MF, Good day! Enhancement 105462 is already a feature available in NetSuite since 2008, which is SOAP WS's search operation. Meanwhile, Enhancement 93655 WS - support search aggregate functions is currently marked for future enhancement.

Hello @User_HKV76, You can update the contact record directly by using {{REST_SERVICES}}/record/v1/contact/{{internal_id}} with the request body containing: { "email": "rosen@zeni.ai" } I hope this helps! Click here for more details. If you find this reply to your question useful, others might as well. By clicking the…

Thanks for providing these information, Dawn! I redacted your account id information as it is considered confidential. First, we need to check if this script is part of a bundle. To do that, you can go to Customization / Scripting / Scripted Record / Click View on Sales Order Once you're there, look for the script with the…

Hi @User_XELYJ, Was I able to address your concern?

Hi @User_8X611, Does it indicate which script is encountering the error? It would also be helpful if you could provide these information: When did this start occurring? Was there any change in your account around the time it started? (Bundle updates or installation, system upgrades, etc.) When exactly do you encounter the…

Hello @User_HKV76, do you also encounter the error when you input it via NetSuite UI?

Hi @User_5OEEE, Welcome to NetSuite Support Community! Upon checking, this feature is currently filed as an enhancement request under 244271 Web Services > Ability to perform a CSV import To support this Enhancement, you can cast your vote on the SuiteIdeas page by following the instructions provided in SuiteAnswers…

Thanks for letting me know! I think it would be best to have our support team to have a look into this. Please raise a case or let me know if you need assistance in creating one.

Hello @Gia My "Mei" Luc, Good day and thank you for posting this new thread! Thanks for providing your insights, @Angela Bayliss😊.

Hello @Tim_1701, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued.

Hello @User_ZC7SF, Good day and thank you for posting this new thread! Hello everyone! Recognizing your expertise and knowledge, we kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.