Happy Business Starts Here

Can not use select all in with ZOQL

Highlighted
Valued Scholar

Can not use select all in with ZOQL

I used "SELECT * FROM PaymentMethod WHERE AccountId = 'XXXXXX'", but it failed. When I change * to particular field (for example AccountId, CreatedDate etc), it will work. Do you know what is the matter with it? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Guru

Re: Can not use select all in with ZOQL

@yihaoye ZOQL does not support "SELECT *" notation (i.e. wildcards). You must specify each field that you want to retrieve. You can see many of the capabilities and limits of ZOQL here:

 

https://knowledgecenter.zuora.com/DC_Developers/K_Zuora_Object_Query_Language

 

While the SOAP API is no longer where active development occurs, it does have good documentation on all the fields that are available via ZOQL:

 

https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference

 

I often use that section as reference when building a query.

View solution in original post

1 REPLY 1
Highlighted
Guru

Re: Can not use select all in with ZOQL

@yihaoye ZOQL does not support "SELECT *" notation (i.e. wildcards). You must specify each field that you want to retrieve. You can see many of the capabilities and limits of ZOQL here:

 

https://knowledgecenter.zuora.com/DC_Developers/K_Zuora_Object_Query_Language

 

While the SOAP API is no longer where active development occurs, it does have good documentation on all the fields that are available via ZOQL:

 

https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference

 

I often use that section as reference when building a query.

View solution in original post