Tickets Tagged With:query
Category: Questions
how to keep string format
We are importing data from our Azure SQL Server database. We have a table with a list of courses and the Course Number is a text field. However, one school ....
Category: Questions
Queries trough API
Hi, can you please tell me if I can use for example Salesforce integration through API ? Because we want to write queries in the code! We want to use ....
Category: Bug Reports
unknown error when running big commerce query
Everytime I try to execute a query using a big commerce connection the query fails with this error Http failure response for https://api.skyvia.com/api/66744/connections/190930/query: 0 Unknown Error The queries have worked ....
Category: Questions
How we can run SOQL inner query in Skyvia?
Hi Team , I have below query to run SELECT Name,ccrz__SKU__c,ccrz__ShortDescRT__c,(select Id,ccrz__Price__c from ccrz__E_PriceListItems__r where ccrz__Pricelist__r.ccrz__PricelistId__c ='UP_Price_Main' LIMIT 1),(select ccrz__URI__c from ccrz__E_ProductMedias__r where ccrz__URI__c != null LIMIT 1) FROM ccrz__E_Product__c ....
Category: Questions
Schedule a Quey
I need to schedule a query to run automatically daily. The Query is: update Products set SortOrder = (InventoryLevel * -1) and it's to a BigCommerce connection. ....
Category: Bug Reports
Netsuite integration fails
Hi, When trying to export Netsuite salesorder table for this year from google sheets, it gets stuck in row 200, saying invalid token. I am guessing it is ....
Category: Questions
Scheduling google sheets refresh via query?
Is it possible to shedule a google sheet to refresh daily using the query? I know we can create schedule action/events in the google api but don't know if it ....
Category: Feature Requests
Salesforce Export and Query of Archives
Queries and exports of data need to support access to the Salesforce archives. Some Salesforce objects have a "recency" component to their data and archive records older than X days. ....
Category: Bug Reports
Unable to purchase
I am unable to purchase a query subscription. I get a 500 error each time I try to activate an endpoint in the production user interface. I get no clear ....
Category: Questions
Can't access NetSuite table
Hi I've configured a Netsuite connection and can access the majority of netsuite tables except for a couple. A really critical table is SalesOrder however I get a generic error ....
Category: Questions
Event Attendance query not pulling any information
Hello, I'm using the query below to try and pull a raw file of attendees at an event we hosted earlier this month. This same query has worked fine for ....
Category: Bug Reports
Google sheets query - refresh is now blanking / erasing the whole sheet
Using the query, have adjusted the setting to "use the current cell" for the location of the refresh so that I could enable some additional fields / equations on the ....
Category: Bug Reports
Query - google sheet - exception: the coordinates or dimensions of the range are invalid
I have a fairly large query (19k rows) that used to run successfully but is now returning with "exception: the coordinates or dimensions of the range are invalid". The query ....