JiwaAPI

<back to all web services

v_Jiwa_GL_PeriodsFromSO_SalesHistoryQuery

Requires Authentication
v_Jiwa_GL_PeriodsFromSO_SalesHistoryQuery Parameters:
NameParameterData TypeRequiredDescription
Year_Noqueryshort?No
Year_NoGreaterThanOrEqualToqueryshort?No
Year_NoGreaterThanqueryshort?No
Year_NoLessThanqueryshort?No
Year_NoLessThanOrEqualToqueryshort?No
Year_NoNotEqualToqueryshort?No
Year_NoBetweenqueryNullable<Int16>[]No
Year_NoInqueryNullable<Int16>[]No
Period_NamequerystringNo
Period_NameStartsWithquerystringNo
Period_NameEndsWithquerystringNo
Period_NameContainsquerystringNo
Period_NameLikequerystringNo
Period_NameBetweenquerystring[]No
Period_NameInquerystring[]No
Period_Start_DatequeryDateTime?No
Period_Start_DateGreaterThanOrEqualToqueryDateTime?No
Period_Start_DateGreaterThanqueryDateTime?No
Period_Start_DateLessThanqueryDateTime?No
Period_Start_DateLessThanOrEqualToqueryDateTime?No
Period_Start_DateNotEqualToqueryDateTime?No
Period_Start_DateBetweenqueryNullable<DateTime>[]No
Period_Start_DateInqueryNullable<DateTime>[]No
Period_End_DatequeryDateTime?No
Period_End_DateGreaterThanOrEqualToqueryDateTime?No
Period_End_DateGreaterThanqueryDateTime?No
Period_End_DateLessThanqueryDateTime?No
Period_End_DateLessThanOrEqualToqueryDateTime?No
Period_End_DateNotEqualToqueryDateTime?No
Period_End_DateBetweenqueryNullable<DateTime>[]No
Period_End_DateInqueryNullable<DateTime>[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
v_Jiwa_GL_PeriodsFromSO_SalesHistory Parameters:
NameParameterData TypeRequiredDescription
Year_Noformshort?No
Period_NameformstringNo
Period_Start_DateformDateTime?No
Period_End_DateformDateTime?No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /xml/reply/v_Jiwa_GL_PeriodsFromSO_SalesHistoryQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<v_Jiwa_GL_PeriodsFromSO_SalesHistoryQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <Period_End_Date>0001-01-01T00:00:00</Period_End_Date>
  <Period_End_DateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </Period_End_DateBetween>
  <Period_End_DateGreaterThan>0001-01-01T00:00:00</Period_End_DateGreaterThan>
  <Period_End_DateGreaterThanOrEqualTo>0001-01-01T00:00:00</Period_End_DateGreaterThanOrEqualTo>
  <Period_End_DateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </Period_End_DateIn>
  <Period_End_DateLessThan>0001-01-01T00:00:00</Period_End_DateLessThan>
  <Period_End_DateLessThanOrEqualTo>0001-01-01T00:00:00</Period_End_DateLessThanOrEqualTo>
  <Period_End_DateNotEqualTo>0001-01-01T00:00:00</Period_End_DateNotEqualTo>
  <Period_Name>String</Period_Name>
  <Period_NameBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Period_NameBetween>
  <Period_NameContains>String</Period_NameContains>
  <Period_NameEndsWith>String</Period_NameEndsWith>
  <Period_NameIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Period_NameIn>
  <Period_NameLike>String</Period_NameLike>
  <Period_NameStartsWith>String</Period_NameStartsWith>
  <Period_Start_Date>0001-01-01T00:00:00</Period_Start_Date>
  <Period_Start_DateBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </Period_Start_DateBetween>
  <Period_Start_DateGreaterThan>0001-01-01T00:00:00</Period_Start_DateGreaterThan>
  <Period_Start_DateGreaterThanOrEqualTo>0001-01-01T00:00:00</Period_Start_DateGreaterThanOrEqualTo>
  <Period_Start_DateIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </Period_Start_DateIn>
  <Period_Start_DateLessThan>0001-01-01T00:00:00</Period_Start_DateLessThan>
  <Period_Start_DateLessThanOrEqualTo>0001-01-01T00:00:00</Period_Start_DateLessThanOrEqualTo>
  <Period_Start_DateNotEqualTo>0001-01-01T00:00:00</Period_Start_DateNotEqualTo>
  <Year_No>0</Year_No>
  <Year_NoBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </Year_NoBetween>
  <Year_NoGreaterThan>0</Year_NoGreaterThan>
  <Year_NoGreaterThanOrEqualTo>0</Year_NoGreaterThanOrEqualTo>
  <Year_NoIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:short>0</d2p1:short>
  </Year_NoIn>
  <Year_NoLessThan>0</Year_NoLessThan>
  <Year_NoLessThanOrEqualTo>0</Year_NoLessThanOrEqualTo>
  <Year_NoNotEqualTo>0</Year_NoNotEqualTo>
</v_Jiwa_GL_PeriodsFromSO_SalesHistoryQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfv_Jiwa_GL_PeriodsFromSO_SalesHistory7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:v_Jiwa_GL_PeriodsFromSO_SalesHistory>
      <d2p1:_x003C_Period_End_Date_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_Period_End_Date_x003E_k__BackingField>
      <d2p1:_x003C_Period_Name_x003E_k__BackingField>String</d2p1:_x003C_Period_Name_x003E_k__BackingField>
      <d2p1:_x003C_Period_Start_Date_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_Period_Start_Date_x003E_k__BackingField>
      <d2p1:_x003C_Year_No_x003E_k__BackingField>0</d2p1:_x003C_Year_No_x003E_k__BackingField>
    </d2p1:v_Jiwa_GL_PeriodsFromSO_SalesHistory>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfv_Jiwa_GL_PeriodsFromSO_SalesHistory7kRqkrSv>