How we can run SOQL inner query in Skyvia?

  • 12Views
  • Last Post 2 days ago
0
votes
Amar Dhaliwal posted this 5 days ago

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 where ccrz__Storefront__c = 'UsedPartsStore' and ccrz__ProductType__c = 'Product' and (CreatedDate = LAST_N_DAYS:7 OR LastModifiedDate= LAST_N_DAYS:7) ORDER BY CreatedDate DESC

I want to export this data to SFTP server , is this inner query supported by Skyvia? if yes, how ?

 

0
votes
Olena Romanchuk posted this 2 days ago

 Hello Amar,

SOQL is not supported by Skyvia.
However, with Skyvia you can run SQL queries against the data source. Skyvia Query is an online SQL client and query builder tool that allows querying and managing cloud and relational data with SQL statements. You can enter SQL statements via code editor or compose SELECT statements with a visual query builder.
Please find more information regarding the supported SQL statements here https://docs.skyvia.com/supported-sql-for-cloud-sources/

best regards, Olena Technical Support Engineer

Close