Hello! I'm trying to send a post request with suiteql in order to get all items, using javascript fetch. It works fine when I use the url "https://<my_account>.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql", but I get a "401 Unauthorized" error when I add limit and offset to the url (like this : "https://<my_account>.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=1000&amp;offset=1000") and I didn't change anything in the authentication method. Any idea ?

Hi all! Is it possible to get a list of files attached to a record via SuiteTalk? My task is quite straightforward - I just need to grab all file attachments for a specific bill and download them. However I do not see any sign of it being doable in the documentation or on the web. I found tips to use SuiteScript or saved searches, but hey, can't this be done via vanilla SuiteTalk request? FileSearch objects don't really have any joins to transaction or other meaningful records (just shopperJoin or userJoin) Almost all other operations with files are supported via SuiteTalk (create/get/attach to record). Please don't break my heart and don't tell me that NS devs didn't implemented proper search for links between files and records. Am I missing something?

When using PHP toolkit to create an Estimate, I got this error: "Could not calculate cost for the selected Realtime rate. Missing/Illegal ShipTo/Address/StateProvinceCode" How to remove address validation in the php script? I set preferences

$service->setPreferences(false, true, true, true);

Hi all...can anyone please letme know how to integrate whatapp with Netsuite.Thanks in advance.

Does anyone have an example of how to handle pricingMatrixList when creating an item through SOAP webservices?

also...is there a webservice channel that i can join?

ah ok, so this is the right channel 🙂

Happy Friday everyone! 🙌 I’m a new NetSuite developer trying to test the application’s REST API. I followed these instructions for enabling TBA in NetSuite and used the account id, access token, token secret, and consumer id/secret for the NetSuite REST API Postman Tutorial. I’m using a sandbox instance. However, I’m getting a

401 Invalid login attempt.

error while trying to submit the very first request. When I check the Login Audit Trail Search within NetSuite, I don’t see any trace of my login attempt. Any pointers on how to debug this issue?

We are receiving the error in the picture, but are not receiving the field, nor is any script showing an error. How can we determine which field is incorrect?

Hi, I'm trying to wrap my head around daylight savings in the Netsuite and I just can't. The task looks soo simple - I just want to get dates as they are shown in the Netsuite UI (but of course they are datetimes under the hood and I can't set pacific timezone for API user for specific reason). I have seen this wonderful Help Center article but I still can't figure it out. Quote #1 from that article:

When getting the date field through SOAP web services, your preferred time zone influences the resulting datetime. Midnight in the user's time zone of the stored date (which is also displayed in the UI) is converted to Pacific Standard Time (PST) or Pacific Daylight Time (PDT), and sent to the SOAP web services user.

Ok, that was easy (before daylight savings started): • API user's timezone is GMT. • Netsuite UI date = 2022-04-18 • Netsuite SOAP date value = 2022-04-17T160000.000-08:00 Totally makes sense, since this is converted to 2022-04-18T000000.000Z and I get the expected date part of 2022-04-18. Quote #2 from the same article:

The NetSuite time zone settings in Home > Set Preferences are based on standard time settings. You must keep in mind the required adjustments during daylight saving time in the year. For example, if your time zone setting in shows (GMT-06:00) Central Time (US & Canada), this is perceived as -05:00 in SOAP web services context during daylight saving time, but -06:00 in standard time.

Therefore, if you send a SOAP web services request indicating CST (-6) when daylight saving time is in effect, as in the following example: <tranDate xsi:type="xsd:dateTime">2015-04-13T222626.923-06:00</tranDate>, the datetime field on the target record is set using CDT (-5) i.e.232626.923 instead of the intended 222626.923.

Important: If the time is close to midnight, the date may change to the next day after the conversion.

With the same API user with GMT timezone and same Netsuite UI date = 2022-04-18 I now receive in SOAP 2022-04-17T160000.000*-07:00* instead of -08:00. By taking the date part this actually converts to 2022-04-1*7* instead of expected 2022-04-1*8* in GMT. Just..why does this happen? And how Netsuite suggests to work with this? Does the bold sentences in quote #2 imply that my client code needs to remember when daylight savings are in effect in my timezone and to account for that 1 hour difference somehow? Am I missing something?

Hello all..I am updating vendor bill sublist via soap web services , but the link between vendor bill and PO missing .Pls give solution for this issue.

Hello, How does perform

REST WS

in comparison to

SOAP WS

? Is it faster? Even compared to SOAP list (bulk) operations?

Hey All, I’m trying to get an app integrated with the SuiteTalk REST Web Services API. I’m trying to get it working in Postman, since I’ve seen that that’s usually easiest to get working first. I’ve followed the instructions I can find, but am continually getting a 401, and when I check the audit trail it’s an

InvalidSignature

. I’ve attached what my request looks like in Postman. Can anyone identify what I’m doing wrong?

Any way to upload files to the NetSuite FILE CABINET via SuiteTalk?

When creating the sales order using REST API {POST /salesOrder} the following error is throws { "detail": "Error while accessing a resource. You have entered an Invalid Field Value 1249 for the following field: shipmethod.", "o:errorCode": "USER_ERROR" } I have verified the shipping method list and seems that shipping method having internal id 1249 is active and available for the subsidiary Please share if anyone have a workaround for the same Thank you

I have a saved search for items with quantity levels (available, back-ordered, committed, on hand, on order) that I am querying through SOAP web services. I get the same amount of results as I do in the UI (3,301), but upon further inspection, I noticed that I am missing 80 items. The reason that the results still come out to 3,301 is that there are 80 duplicates. I performed the same query on the production site just to see if this was some quirk with the sandbox. The production query had 79 missing items and 79 duplicates to make up the difference, but the items that are duplicated and missing are different from the sandbox. Has anyone experienced this issue before? I even tried changing the amount of results I get thinking that somehow running only 200 results per query was returning duplicates, but changing it to 2,000 results per query still returned the same amount of duplicates.

Hi all, I wasn't sure of the best place to post this but wanted to share something that I've found incredibly useful. There is a free, open-source tool called N8N (n8n.io) for low-code automation. I've put together a custom node that allows you to integrate with the REST API v1. I'm working on documenting it now, but feel free to ping me if you'd like to try it out.

is there an endpoint to mass create a work order Reorder Point Items

Hello Team, I need your help with the following question. In NetSuite, the client created an Invoice. The Invoice is opened (unpaid). Then, using API, my application received this Invoice. I mean NetSuite returned the Invoice via API. After that, using API I created a payment with allocation to this Invoice. But, NetSuite API returned me the following errors: <platformCore:message>That record does not exist.</platformCore:message> Unable to find a matching line for sublist apply with key: [doc, line] and value: [....] What can be the reason why NetSuite cannot find the Invoice that is active in NetSuite? Unfortunately, I cannot open the client's account to try to create a payment with allocation to this Invoice and check.

RMAs don't have a proper (Address subrecord)

shippingAddress

like other transactions. Is this a known bug?

A bunch of people wasted a whole lot of time here today trying to figure out why REST API requests wouldn't work even though the company option was enabled and the role had REST Web Services permission, only to eventually stumble upon the fact that it also requires SuiteAnalytics Workbook permission. Why? We weren't trying to do anything with a workbook. Grrr. Definitely not following the Principle of Least Surprise

Hi all! When doing an upsert on vendor records, if I include an address and the vendor already exists, it duplicates the address even if it's identical to one that already exists. What's the right way to NOT duplicate addresses on vendor upserts?

Ok next question: After a sandbox refresh my integration lost all its credentials. I've re-created the integration and the access token and but the consumer and token credentials in Boomi but still get a login failure and no reason for it shows up in the login audit trail (it just says failure with no further info). How can I troubleshoot this?

Struggling to set a null value on a custom segment using SuiteTalk upsert. This works just fine to set a value:

<employee:customFieldList>

<core:customField scriptId="cseg_my_custom_segment" xsi:type="core:SelectCustomFieldRef">

<value internalId="1"/>

</core:customField>

</employee:customFieldList>

But how do I unset that value? I tried I few variations similar to

<value/>

and

<value internalId=""/>

but can’t find anything that will set that field to

null

.

I'm trying to use the Saved Search option in Jitterbit, but it's greyed out (actually on all custom records). The role being used by the integration can access custom records though? The Jitterbit folks think it's a permission thing. I was wondering if anyone faced this issue?

I am trying to connect to the NetSuite REST API. I have the API authenticating correctly, and can access the data for specific customers (e.g.

/customer/123

). However, attempting to call

/customer

(endpoint for a list of customers) returns me a 400 error, even though I believe I have all the correct permissions and parameters. I've tried with and without the

q

parameter. Could someone please advise what I am missing here? (see my attached screenshots)

Hi all! Does anyone else here use Boomi for sending entities to NS via SuiteTalk? I'm trying to figure out how to include separate billing and shipping addresses because Boomi only has a place for one address in addressBookAddress

Also, on custom list fields, SuiteTalk is expecting the list ID of the selected value, isn't it? Sometimes it's throwing an error saying to select a value and sometime it's not, even though I'm using the same XML and value for both...

This message was deleted.

When SPS Commerce is sending the request without order line attribute to create item fulfillment, it works. But when I am trying that same payload, it is throwing an error that I need to specify the order line.