function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Viktor IlyuhinViktor Ilyuhin 

How make select data from order object

Hi

I need to get order data through WSDL AIP. When I call query "Select id from order", I receive 

MALFORMED_QUERY: 
select id from Order  order by Id desc 
              ^
ERROR at Row:1:Column:15
line 1:15 no viable alternative at character '"'

I understand Order's object is conflicting with sentence "order by". 

How get data order ?
Purushotham YellankiPurushotham Yellanki
Hi Viktor,

I don't see any issue with your Query. I tried running it on my Developer Cosole and I do see that it is working. There must be some typo in your Query.

Query that I used: "Select Id, AccountId, ContractId, CreatedDate From Order Order By Id Desc"

User-added image
Viktor IlyuhinViktor Ilyuhin
Hi Purushotham,
A lot of thanks for your answer. It is working now