Skip to content

API SOAP Orders sorting doesn't work #6439

@MaximKitsenko

Description

@MaximKitsenko

steps to reproduce:
Make API call with this body:

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:def="http://hereshouldbeyourmagentostoreurl.com/soap/default?services=salesOrderRepositoryV1"><soap:Header/>
   <soap:Body>
      <def:salesOrderRepositoryV1GetListRequest>
         <searchCriteria>
            <filterGroups>
               <!--Zero or more repetitions:-->

            </filterGroups>
            <!--Optional:-->

            <!--Optional:-->

            <!--Optional:-->
            <sortOrders><item><field>createdAt</field><direction>DESC</direction></item></sortOrders><pageSize>100</pageSize><currentPage>1</currentPage>
         </searchCriteria>
      </def:salesOrderRepositoryV1GetListRequest>
   </soap:Body>
</soap:Envelope>

Th answer is:

<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope" >
   <env:Body>
      <env:Fault>
         <env:Code>
            <env:Value>env:Receiver</env:Value>
         </env:Code>
         <env:Reason>
            <env:Text xml:lang="en">Internal Error. Details are available in Magento log file. Report ID: webapi-57c80c791008f</env:Text>
         </env:Reason>

      </env:Fault>
   </env:Body>
</env:Envelope>

The problem is in sorting since when i removed this field:

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:def="http://hereshouldbeyourmagentostoreurl.com/soap/default?services=salesOrderRepositoryV1">
   <soap:Header/>
   <soap:Body>
      <def:salesOrderRepositoryV1GetListRequest>
         <searchCriteria>
            <filterGroups>
               <!--Zero or more repetitions:-->

            <item><filters><item><field>updated_At</field><value>2016-03-10 20:24:00</value><conditionType>gt</conditionType></item><item><field>updated_At</field><value>2016-09-10 20:24:00</value><conditionType>lt</conditionType></item></filters></item></filterGroups>
            <!--Optional:-->

            <!--Optional:-->

            <!--Optional:-->
            <pageSize>100</pageSize><currentPage>1</currentPage>
         </searchCriteria>
      </def:salesOrderRepositoryV1GetListRequest>
   </soap:Body>
</soap:Envelope>

I received correct answer:

<?xml version="1.0" encoding="UTF-8"?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope" xmlns:ns1="http://hereshouldbeyourmagentostoreurl.com/soap/default?services=salesOrderRepositoryV1">
    <env:Body>
        <ns1:salesOrderRepositoryV1GetListResponse>
            <result>
                <items>
                    <item>
                        <baseCurrencyCode>USD</baseCurrencyCode>
                        <baseDiscountAmount>0</baseDiscountAmount>
                        <baseGrandTotal>16</baseGrandTotal>
...

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions