suiteQL – NetSuite Professionals

Question Tag: suiteQL

All Questions

Filter by

Questions Per Page:

Billing Schedule Details with Workbook or SuiteQL
I’ve got the following SuiteAnalytics Connect query that returns the billing schedule for a sales order without tax (the UI …
analytics

suiteQL

workbook

Mike Robbins Rookie Asked 4 days ago in Workbooks.
- 39 views
- 0 answers
- 0 votes
How to fetch all roles via SOAP API that are present on Manage Role UI in NetSuite
Hi Team, We can get all users details from SOAP. API example : using API. But How we can get …
employee

roles

SOAP

suiteQL

suitetalk

SurajKudale Rookie Asked on April 2, 2021 in SuiteTalk.
- 63 views
- 0 answers
- 0 votes
What is subsidiary in NetSuite and How to fetch it via webservices
Hi Team, What is subsidiary in NetSuite. is it possible to Create subsidiary without NetSuite oneWorld account . If no …
oneworld

SOAP

subsidiary

suiteQL

suitetalk

SurajKudale Rookie Asked on April 2, 2021 in SuiteTalk.
- 58 views
- 2 answers
- 0 votes
How to get latest modified support cases
Hi, I found a problem how to filter SupportCases by its lastModifiedDateTime attribute. It’s exposed by SOAP or RESTlet schemas, …
API

suiteQL

Lukasz Rookie Asked on March 23, 2021 in SuiteApps.
- 78 views
- 0 answers
- 0 votes
Can the REST API be used to get custom fields from inventory numbers?
I’m using the query /suiteql endpoint. https://#######-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql/?limit=20 The body queries an inventorynumber. { “q”:”SELECT * FROM inventorynumber WHERE inventorynumber.inventorynumber = …
API

inventory

suiteQL

suitetalk

jamesvg Rookie Asked on March 10, 2021 in SuiteTalk.
- 170 views
- 0 answers
- 0 votes
Using LISTAGG or NS_CONCAT in a SuiteQL query
I am attempting to concatenate all the rows in a column into a single comma separated string, but I receive …
suiteQL

kylejones Rookie Asked on February 15, 2021 in SuiteAnalytics.
- 127 views
- 1 answers
- 0 votes
SuiteQL query executed through REST web services returns truncated field names
When executing the SuiteQL query below, custom field names longer than 26 characters are being truncated to 25 characters with …
API

Query

suiteQL

martyychang Rookie Asked on December 30, 2020 in SuiteAnalytics.
- 170 views
- 0 answers
- 0 votes
Issues Generating a REST Web Services Signature
Anyone have any insight into creating the signature for a REST API SuiteQL signature? I have one for authenticating and …
OAuth

suiteQL

Token-Based Authentication

CharlesBastian Rookie Asked on December 9, 2020 in SuiteTalk.
- 345 views
- 3 answers
- 0 votes
NetSuiteDW as new data source via SuiteAnalytics ODBC Connect?
Hello – anyone has any idea about this new data source NetSuiteDW available under SuiteAnalytics Connect via ODBC ? Few …
analytics

Connect Browser

suiteQL

manik Rookie Asked on November 4, 2020 in SuiteAnalytics Connect.
- 307 views
- 0 answers
- 0 votes
get fields of table for suiteQL
When using a suiteQL and running such a query it return status 400 and the call fails. After removing image …
API

Query

suiteQL

animheryan Rookie Asked on October 29, 2020 in SuiteAnalytics Connect.
- 660 views
- 1 answers
- 0 votes