sanimesa

@Jack Daryl Espiel-Oracle Ok great, thanks!

in SuiteAnalytics / ODBC Object TransactionLine column dropped? Comment by sanimesa Sep 7, 2022 9:18PM

@Jack Daryl Espiel-Oracle Here is a screenshot:

in SuiteAnalytics / ODBC Object TransactionLine column dropped? Comment by sanimesa Sep 7, 2022 7:50PM

@Jack Daryl Espiel-Oracle We are using NetSuite2.com. The field is not inactive, yet do not see it when we retrieve fields. Please see screenshots. What else could have changed?

in SuiteAnalytics / ODBC Object TransactionLine column dropped? Comment by sanimesa Sep 7, 2022 6:02PM

@Michelle Jabanes-Oracle The issue was resolved at our end, feel free to delete the thread. Thanks.

in Error creating token - Unable to parse provided authentication string (Solved) Comment by sanimesa Apr 6, 2022 11:41AM

@Mikko De La Fuente-Oracle How can we access reports using ODBC? We have a financial report (budget vs actual) which we need to access. Is only a subset of NetSuite data available through ODBC? We were under the impression all of NetSuite data would be available using this mechanism. Thanks.

in Table name not found from ODBC / SuiteAnalytics Connect Comment by sanimesa Apr 4, 2022 9:38PM

Thanks for this, will check this out. Specifically we are looking to extract the Budget object, this is not available on the REST API browser but is part of NetSuite schema. There are existing reports that presumably use this object.…

in Access to Budget vs Actual Reports using REST API Comment by sanimesa Jan 27, 2022 6:13PM

Indeed it was a role related issue, the objects work when the role is added. Thanks!

in Getting INVALID_PARAMETER/INVALID_METHOD on many of the REST API objects Comment by sanimesa Dec 15, 2021 10:54PM

I am trying to get a list, not a specific customer, this is as per:

in Getting INVALID_PARAMETER/INVALID_METHOD on many of the REST API objects Comment by sanimesa Dec 13, 2021 10:02PM

Just wondering if a specialist can take a quick look? Thanks.

in Getting INVALID_PARAMETER/INVALID_METHOD on many of the REST API objects Comment by sanimesa Dec 13, 2021 5:47PM

Adding a picture of how it looks on Postman. [Image removed]

in Getting INVALID_PARAMETER/INVALID_METHOD on many of the REST API objects Comment by sanimesa Dec 10, 2021 5:29PM

I am just trying to retrieve records using the REST API from various API objects. I am able to retrieve records for some objects, while the others are giving me that error. The exact same code in python is used. Many objects expectedly have 0 records, which is fine. But why are so many objects gving…

in Getting INVALID_PARAMETER/INVALID_METHOD on many of the REST API objects Comment by sanimesa Dec 10, 2021 5:15PM

It worked after following that example. It would really help if working Python code examples of REST API are made available. Thanks!

in Unable to make REST Web Service suiteql work in Python Comment by sanimesa Dec 10, 2021 3:05PM

Ok - that finally worked. I did try enclosing in single quotes before which did not work. This is the version that worked: r = requests.get(url_api+'/'+module, headers=header_api, params={'q':'lastModifiedDate ON_OR_AFTER "11/1/2021"'}) Thanks for your help!

in REST Webservice filtering records on date - unable to make it work in Python Comment by sanimesa Dec 9, 2021 11:18PM

Getting the same error after setting content type as text/plain. Thanks.

in Unable to make REST Web Service suiteql work in Python Comment by sanimesa Dec 9, 2021 10:42PM

As I mentioned, I tried with different date formats and none of them worked. The below request produces a different error: r = requests.get(url_api+'/'+module, headers=header_api, params={"q":"lastModifiedDate ON_OR_AFTER 11/1/2021"}) {"type": "https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1", "title":…

in REST Webservice filtering records on date - unable to make it work in Python Comment by sanimesa Dec 9, 2021 10:39PM

MFA for Oracle Community

sanimesa Green Ribbon

Comments