Toplu Kayıt Okuma (getPage)

Bu fonksiyonu çağırırken oturum anahtarı (Session ID) veya Temel Kimlik Doğrulaması (Basic Authentication) kullanılabilir.

Parametre Adı	Veri Tipi	Açıklama
Period	xs:intZorunlu Alan	Geçerli yasal kuruma ait dönem kayıt no değeri
InputType	xs:String	Tavsiye edilen değer : xml
OutputType	xs:String	Tavsiye edilen değer : xml2
EntityName	xs:StringZorunlu Alan	Orkestra nesne tarayıcısından alınan nesneye ait sınıf adı
ClassType	xs:intZorunlu Alan	Orkestra nesne tarayıcısından alınan sınıf alt türü. Buraya verilecek değer mutlaka nesne tarayıcısından kontrol edilmelidir.
Fields	xs:String	Orkestra nesne tarayıcısından alınan alan adlarının listesi. Birden fazla alan belirtilebilir. Alt nesnelere ait alanlara . (nokta) ayıracı ile erişilebilir.
PageSize	xs:int	Sayfa başına verilecek veri miktarı.
PageIndex	xs:int	Sayfa numarası. (İlk sayfanın indeks değeri 0 dan başlar.)
Filters	xs:Object	Okumak istediğiniz kayıtlar ile ilgili olarak filtreleme yapılabilmektedir.
OrderBy	xs:Object	Okumak istediğiniz kayıtlar için sıralama.

Örnek İstem Şablonu( Request )

Nesne Adı(EntityName) : StockItem (Ürün/Hizmet)

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ws="http://ws.server.orkestra.com.tr">
   <soap:Header/>
   <soap:Body>
      <ws:getPage>
         <!--Optional:-->
         <params>
            <!--Optional:-->
            <Period>?</Period>
            <!--Optional:-->
            <InputType>?</InputType>
            <!--Optional:-->
            <OutputType>?</OutputType>
            <!--Optional:-->
            <EntityName>?</EntityName>
            <ClassType>?</ClassType>
            <!--Zero or more repetitions:-->
            <Fields>?</Fields>
            <PageSize>?</PageSize>
            <!--Optional:-->
            <PageIndex>?</PageIndex>
            <!--Zero or more repetitions:-->
            <Filters>
               <!--Optional:-->
               <Type>?</Type>
               <!--Optional:-->
               <NumValue>?</NumValue>
               <!--Optional:-->
               <StringValue>?</StringValue>
               <!--Optional:-->
               <Property>?</Property>
               <!--Optional:-->
               <Operator>?</Operator>
            </Filters>
            <!--Zero or more repetitions:-->
            <OrderBy>
               <!--Optional:-->
               <Property>?</Property>
               <Desc>?</Desc>
            </OrderBy>
         </params>
      </ws:getPage>
   </soap:Body>
</soap:Envelope>

Örnek İstek (Request)

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:ws="http://ws.server.orkestra.com.tr">
   <soap:Header/>
   <soap:Body>
      <ws:getPage>         
         <params>            
            <Period>123</Period>            
            <InputType>xml</InputType>            
            <OutputType>xml2</OutputType>
            
            <EntityName>com.gtech.erp.inventory.objects.StockItem</EntityName>
            <ClassType>0</ClassType>            
            <Fields>reference</Fields>
            <Fields>code</Fields>
            <Fields>description</Fields>
            <Fields>basePack.code</Fields>
            <Fields>priceDefault</Fields>
            <Fields>priceCurrency.code</Fields>
            <Fields>priceCurrency.reference</Fields>
            
            <PageSize>10</PageSize>            
            <PageIndex>0</PageIndex>

		<!-- reference > 0 -->
		 <Filters>               
               <Type>LONG</Type>               
               <NumValue>0</NumValue>
               <Property>reference</Property>
               <Operator>&gt;</Operator>
            </Filters>

		<!-- reference< 100 000  -->
  		 <Filters>               
               <Type>LONG</Type>               
               <NumValue>100000</NumValue>
               <Property>reference</Property>
               <Operator>&lt;</Operator>
            </Filters>

		<!-- code LIKE '%ab%'  -->
            <Filters>               
               <Type>STRING</Type>               
               <StringValue>%ab%</StringValue>
               <Property>code</Property>
               <Operator>LIKE</Operator>
            </Filters>

	     <!-- ORDER BY reference DESC -->
            <OrderBy>               
               <Property>reference</Property>
               <Desc>TRUE</Desc>
            </OrderBy>
            
        </params>
      </ws:getPage>
   </soap:Body>
</soap:Envelope>

Örnek Cevap ( Response )

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">
   <soap:Body>
      <ns2:getPageResponse xmlns:ns2="http://ws.server.orkestra.com.tr">
         <return>PGRhdGE+Cjxyb3c+CjxyZWZlcmVuY2U+MjQ4OTwvcmVmZXJlbmNlPgo8Y29kZT5DaXR5IDYwMjM5IFBvbGlzIERldnJpeWUgQXJhYmFzxLE8L2NvZGU+CjxkZXNjcmlwdGlvbj5MRUdPwq4gQ2l0eSA2MDIzOSBQb2xpcyBEZXZyaXllIEFyYWJhc8SxIFlhcMSxbSBTZXRpIC0gw4dvY3VrIE95dW5jYWsgQXJhYmE8L2Rlc2NyaXB0aW9uPgo8YmFzZVBhY2suY29kZT5BZGV0PC9iYXNlUGFjay5jb2RlPgo8cHJpY2VEZWZhdWx0PjIwMDA8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjI3NDM8L3JlZmVyZW5jZT4KPGNvZGU+RmFiZXIgQ2FzdGVsbCA5MDAwIERlcmVjZWxpIEthbGVtPC9jb2RlPgo8ZGVzY3JpcHRpb24+RmFiZXIgQ2FzdGVsbCA5MDAwIERlcmVjZWxpIEthbGVtIEFydCBTZXQgKDhiLTJoKSAxNDQ8L2Rlc2NyaXB0aW9uPgo8YmFzZVBhY2suY29kZT5BZGV0PC9iYXNlUGFjay5jb2RlPgo8cHJpY2VEZWZhdWx0Pjc1Ljk8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjI3OTc8L3JlZmVyZW5jZT4KPGNvZGU+RmFiZXItQ2FzdGVsbCBPdmFsIMWeZWZmYWY8L2NvZGU+CjxkZXNjcmlwdGlvbj5GYWJlci1DYXN0ZWxsIE92YWwgxZ5lZmZhZiBHw7Z2ZGVsaSBTaWxnaWxpIEthbGVtdMSxcmHFnzwvZGVzY3JpcHRpb24+CjxiYXNlUGFjay5jb2RlPkFkZXQ8L2Jhc2VQYWNrLmNvZGU+CjxwcmljZURlZmF1bHQ+NDA8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjI3OTg8L3JlZmVyZW5jZT4KPGNvZGU+RmFiZXItQ2FzdGVsbCDDnMOnZ2VuIEt1cnUgQm95YSBLYWxlbWk8L2NvZGU+CjxkZXNjcmlwdGlvbj5GYWJlci1DYXN0ZWxsIMOcw6dnZW4gS3VydSBCb3lhIEthbGVtaSAxMiZhcG9zO2xpICsgS2FsZW10xLFyYcWfPC9kZXNjcmlwdGlvbj4KPGJhc2VQYWNrLmNvZGU+QWRldDwvYmFzZVBhY2suY29kZT4KPHByaWNlRGVmYXVsdD4yMDwvcHJpY2VEZWZhdWx0Pgo8cHJpY2VDdXJyZW5jeS5jb2RlLz4KPHByaWNlQ3VycmVuY3kucmVmZXJlbmNlLz4KPC9yb3c+Cjxyb3c+CjxyZWZlcmVuY2U+Mjc5OTwvcmVmZXJlbmNlPgo8Y29kZT5GYWJlci1DYXN0ZWxsIFN1bHUgQm95YSAxMiZhcG9zO2xpICsgRsSxcsOnYTwvY29kZT4KPGRlc2NyaXB0aW9uPkZhYmVyLUNhc3RlbGwgU3VsdSBCb3lhIDEyJmFwb3M7bGkgKyBGxLFyw6dhPC9kZXNjcmlwdGlvbj4KPGJhc2VQYWNrLmNvZGU+QWRldDwvYmFzZVBhY2suY29kZT4KPHByaWNlRGVmYXVsdD4xMDA8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjMzNTY5PC9yZWZlcmVuY2U+Cjxjb2RlPlRTVC4xODguNS42LjEyMzQ1Njc4OTAwMDAwMC5hYmPDp2RlZi4yMDI0MDMwNy5ILjExMTMyNjUuOS45OTk5OTk5OTk5OTk5OTk8L2NvZGU+CjxkZXNjcmlwdGlvbi8+CjxiYXNlUGFjay5jb2RlPkFkZXQ8L2Jhc2VQYWNrLmNvZGU+CjxwcmljZURlZmF1bHQ+NjU8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjMzODc2PC9yZWZlcmVuY2U+Cjxjb2RlPmZhYmVyIGthbGVtPC9jb2RlPgo8ZGVzY3JpcHRpb24vPgo8YmFzZVBhY2suY29kZT5BZGV0PC9iYXNlUGFjay5jb2RlPgo8cHJpY2VEZWZhdWx0PjA8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjMzODgzPC9yZWZlcmVuY2U+Cjxjb2RlPmFiYW50IHN1PC9jb2RlPgo8ZGVzY3JpcHRpb24vPgo8YmFzZVBhY2suY29kZT50ZXN0PC9iYXNlUGFjay5jb2RlPgo8cHJpY2VEZWZhdWx0PjA8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjMzODkyPC9yZWZlcmVuY2U+Cjxjb2RlPnNhYnVuPC9jb2RlPgo8ZGVzY3JpcHRpb24vPgo8YmFzZVBhY2suY29kZT5BZGV0PC9iYXNlUGFjay5jb2RlPgo8cHJpY2VEZWZhdWx0PjA8L3ByaWNlRGVmYXVsdD4KPHByaWNlQ3VycmVuY3kuY29kZS8+CjxwcmljZUN1cnJlbmN5LnJlZmVyZW5jZS8+Cjwvcm93Pgo8cm93Pgo8cmVmZXJlbmNlPjMzOTAwPC9yZWZlcmVuY2U+Cjxjb2RlPnPEsXbEsSBzYWJ1bjwvY29kZT4KPGRlc2NyaXB0aW9uLz4KPGJhc2VQYWNrLmNvZGU+R3JhbTwvYmFzZVBhY2suY29kZT4KPHByaWNlRGVmYXVsdD4wPC9wcmljZURlZmF1bHQ+CjxwcmljZUN1cnJlbmN5LmNvZGUvPgo8cHJpY2VDdXJyZW5jeS5yZWZlcmVuY2UvPgo8L3Jvdz4KPC9kYXRhPgo=</return>
      </ns2:getPageResponse>
   </soap:Body>
</soap:Envelope>

Örnek Cevabın Base64 Decoded Sonucu

Cevabın içerisinde yer alan return etiketi içerisindeki metin base64 decode fonksiyonuna geçilerek json veya xml elde edilir.

<data>
<row>
    <reference>2489</reference>
    <code>City 60239 Polis Devriye Arabası</code>
    <description>LEGO® City 60239 Polis Devriye Arabası Yapım Seti - Çocuk Oyuncak Araba</description>
    <basePack.code>Adet</basePack.code>
    <priceDefault>2000</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>2743</reference>
    <code>Faber Castell 9000 Dereceli Kalem</code>
    <description>Faber Castell 9000 Dereceli Kalem Art Set (8b-2h) 144</description>
    <basePack.code>Adet</basePack.code>
    <priceDefault>75.9</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>2797</reference>
    <code>Faber-Castell Oval Şeffaf</code>
    <description>Faber-Castell Oval Şeffaf Gövdeli Silgili Kalemtıraş</description>
    <basePack.code>Adet</basePack.code>
    <priceDefault>40</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>2798</reference>
    <code>Faber-Castell Üçgen Kuru Boya Kalemi</code>
    <description>Faber-Castell Üçgen Kuru Boya Kalemi 12&apos;li + Kalemtıraş</description>
    <basePack.code>Adet</basePack.code>
    <priceDefault>20</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>2799</reference>
    <code>Faber-Castell Sulu Boya 12&apos;li + Fırça</code>
    <description>Faber-Castell Sulu Boya 12&apos;li + Fırça</description>
    <basePack.code>Adet</basePack.code>
    <priceDefault>100</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>33569</reference>
    <code>TST.188.5.6.123456789000000.abcçdef.20240307.H.1113265.9.999999999999999</code>
    <description/>
    <basePack.code>Adet</basePack.code>
    <priceDefault>65</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>33876</reference>
    <code>faber kalem</code>
    <description/>
    <basePack.code>Adet</basePack.code>
    <priceDefault>0</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>33883</reference>
    <code>abant su</code>
    <description/>
    <basePack.code>test</basePack.code>
    <priceDefault>0</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>33892</reference>
    <code>sabun</code>
    <description/>
    <basePack.code>Adet</basePack.code>
    <priceDefault>0</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
<row>
    <reference>33900</reference>
    <code>sıvı sabun</code>
    <description/>
    <basePack.code>Gram</basePack.code>
    <priceDefault>0</priceDefault>
    <priceCurrency.code/>
    <priceCurrency.reference/>
</row>
</data>

ORKESTRA