Ari Heitner Red Ribbon

@Richard James Uri-Oracle still seeing the same problem 😀 I am going to a bit aggressively require the system to go back further in time, maybe 10 minutes, every time it runs, and see if that helps. I will post some cycle logs. Ari

@Richard James Uri-Oracle that is a very good point, I will try it and report back (will be a day or two to gather data…) thanks! Ari

@Richard James Uri-Oracle any thoughts on this one? It is very strange that SuiteQL is literally returning us some data sometimes, but often missing records, when they are created close to the time of the query… 🙃

@Richard James Uri-Oracle and everyone - this is an important point you have brought up and this enhancement request is very critical: If your system is making changes to the records you are querying with the REST API, and you are making multiple requests using LIMIT and OFFSET, the records are returned in order of…

@Richard James Uri-Oracle let me be more clear: The goal here is to get all transactions since a given date. The problem is, it takes time to get all transactions - I must do the query above, get the list of transactions, then fetch the transaction one-by-one. In practice, we retrieve a batch of tranId's, then fetch those…

@Richard James Uri-Oracle I did a test and I think I found the problem: I did a request that returns a few hundred records (<1000) and it did return the record. I think the problem is that I am doing a query that returns many thousands of records, without any ORDER BY statement - which means that as I do repeated requests…

@Francesca Nicole Mendoza-Oracle we have checked again and the query is working great, thanks! Ari

@Francesca Nicole Mendoza-Oracle thanks for that suggestion, we will check that and update here.

@Francesca Nicole Mendoza-Oracle yes, I would appreciate if you could open a case for this! It does happen only intermittently, but we need to figure out what is causing it. thanks, Ari

Hi @Francesca Nicole Mendoza-Oracle ! No issue when creating via NetSuite UI, and there is nothing we can see that is special or unique about this Vendor Bill. We are creating dozens of them without problem. We got this error when creating VendorBills for a particular Vendor last November, for maybe 2 weeks running - then…

@Richard James Uri-Oracle yes, the 1st, 3rd, and 6th of those Enhancements appear to be identical to our issue. We found one other suggestion here: https://www.reddit.com/r/Netsuite/comments/v492q9/cannot_get_a_refresh_token/?rdt=62002 Would using an M2M Auth Flow solve our problem? thanks, Ari

@Richard James Uri-Oracle ok, thanks for that. This is the exact process we are doing. The problem is, the refresh token is only valid for a matter of days or maybe a week - we need a way to refresh the refresh token so that the NetSuite connected app can remain active for longer. This is a critical issue for our…

@Richard James Uri-Oracle we are getting new access tokens on a regular basis - here is (a pieces of) the access token for an active connection yesterday at 15:22UTC: eyJraWQiOiJjLjYyMzQz [ ...snip!... ] _3up3G6ut9V4OHNhnjQcBwjcUeGuw and here is the token now for the same connection: eyJraWQiOiJjLjYyMzQz [ ...snip!...]…

@Richard James Uri-Oracle we are still trying to solve this problem, it is critical for our customers. We are getting a refresh token, and using it successfully for a limited period of time - however, it then stops working and the connection terminates. Would it be helpful to share you examples of the tokens (access +…

@Richard James Uri-Oracle we make software which interoperates with NetSuite via the REST API. Our code receives an access token and a refresh token at authentication time. Eventually, that refresh token expires. We have found no way to get an updated refresh token. Other systems with which we integrate using OAuth2.0 give…

@Richard James Uri-Oracle yes, we are are that the access token expires. We use the refresh token provided at authentication time to get a new access token. But eventually the refresh token expires, and then we cannot get a new access token. Is there a way to get a new refresh token, or control how long the refresh token…

@Mikko De La Fuente-Oracle the "Find Transaction" permission seems to have been the key, thanks so much!! Ari

@Mikko De La Fuente-Oracle do we need a higher permission than "View" for Sales Order Reports or Transaction Detail? Ari

@Mikko De La Fuente-Oracle thanks for the suggestion. That permission is already present and set to "Edit". Any other thoughts? thanks! Ari

@Mikko De La Fuente-Oracle just wanted to add what we collected from the audit log: This produced a funny error message: {"type":"https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1","title":"Bad Request","status":400,"o:errorDetails":[{"detail":"Invalid search query. Detailed unprocessed description follows.…

@Mikko De La Fuente-Oracle thanks so much for jumping on! I'm not sure I understand your question. Yes, using the REST API we can read whichever individual invoice we want. We are only getting the error when we do the request which should return a list of all the invoices. thanks, Ari

@JohnCirocco thanks, that sounds like a great way of doing it. One wrinkle: we're not finding "Paying Transaction: Type" in the drop-down list of filter options in the Criteria tab: Is there something we need to do to make that appear? We may have the same question when it comes to getting "Paying Transaction: Date" from…

@Joahnna Given Uy-Oracle thank you very much, that worked perfectly!

@Mikko De La Fuente-Oracle thanks! We are trying the Saved Search / Custom Field route, sounds like a good solution! Ari

Yes @Erick Dela Rosa-Oracle, with "Edit" permission the problem disappears! We would love to see the ability to read data with reduced permissions as a future feature for REST API.... thanks, Ari

@Erick Dela Rosa-Oracle will do! (overnight your time) thanks, Ari

@Erick Dela Rosa-Oracle the customer enabled NetSuite Beta REST features (see attached screenshot) but we're still getting the error message, "Invalid login attempt..." like we were originally getting above. (Just to note, as above, we are getting the access token successfully) Any suggestions? thanks, Ari

Hi @Erick Dela Rosa-Oracle, Thanks so much for following up with this! I will give you details via PM because it involves a specific customer. Ari

@Erick Dela Rosa-Oracle thanks, we are checking and will get back to you with confirmation! -Ari

Just want to add the resolution - we checked all of the above, and the authentication started working. Thanks everyone who contributed! --Ari