JiwaAPI

GL_AutoJournalLinesQuery

**GL_AutoJournalLinesQuery** Parameters:
Name	Parameter	Data Type	Required
RecID	query	string	No
RecIDStartsWith	query	string	No
RecIDEndsWith	query	string	No
RecIDContains	query	string	No
RecIDLike	query	string	No
RecIDBetween	query	string[]	No
RecIDIn	query	string[]	No
GL_AutoJournals_RecID	query	string	No
GL_AutoJournals_RecIDStartsWith	query	string	No
GL_AutoJournals_RecIDEndsWith	query	string	No
GL_AutoJournals_RecIDContains	query	string	No
GL_AutoJournals_RecIDLike	query	string	No
GL_AutoJournals_RecIDBetween	query	string[]	No
GL_AutoJournals_RecIDIn	query	string[]	No
GL_Sets_RecID_Source	query	string	No
GL_Sets_RecID_SourceStartsWith	query	string	No
GL_Sets_RecID_SourceEndsWith	query	string	No
GL_Sets_RecID_SourceContains	query	string	No
GL_Sets_RecID_SourceLike	query	string	No
GL_Sets_RecID_SourceBetween	query	string[]	No
GL_Sets_RecID_SourceIn	query	string[]	No
GL_Sets_SourceDescription	query	string	No
GL_Sets_SourceDescriptionStartsWith	query	string	No
GL_Sets_SourceDescriptionEndsWith	query	string	No
GL_Sets_SourceDescriptionContains	query	string	No
GL_Sets_SourceDescriptionLike	query	string	No
GL_Sets_SourceDescriptionBetween	query	string[]	No
GL_Sets_SourceDescriptionIn	query	string[]	No
PostingDue	query	DateTime?	No
PostingDueGreaterThanOrEqualTo	query	DateTime?	No
PostingDueGreaterThan	query	DateTime?	No
PostingDueLessThan	query	DateTime?	No
PostingDueLessThanOrEqualTo	query	DateTime?	No
PostingDueNotEqualTo	query	DateTime?	No
PostingDueBetween	query	DateTime[]	No
PostingDueIn	query	DateTime[]	No
Reason	query	string	No
ReasonStartsWith	query	string	No
ReasonEndsWith	query	string	No
ReasonContains	query	string	No
ReasonLike	query	string	No
ReasonBetween	query	string[]	No
ReasonIn	query	string[]	No
GL_Sets_RecID_Destination	query	string	No
GL_Sets_RecID_DestinationStartsWith	query	string	No
GL_Sets_RecID_DestinationEndsWith	query	string	No
GL_Sets_RecID_DestinationContains	query	string	No
GL_Sets_RecID_DestinationLike	query	string	No
GL_Sets_RecID_DestinationBetween	query	string[]	No
GL_Sets_RecID_DestinationIn	query	string[]	No
ItemNo	query	int?	No
ItemNoGreaterThanOrEqualTo	query	int?	No
ItemNoGreaterThan	query	int?	No
ItemNoLessThan	query	int?	No
ItemNoLessThanOrEqualTo	query	int?	No
ItemNoNotEqualTo	query	int?	No
ItemNoBetween	query	int[]	No
ItemNoIn	query	int[]	No
RowHash	query	byte[]	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**GL_AutoJournalLines** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
GL_AutoJournals_RecID	form	string	No
GL_Sets_RecID_Source	form	string	No
GL_Sets_SourceDescription	form	string	No
PostingDue	form	DateTime	No
Reason	form	string	No
GL_Sets_RecID_Destination	form	string	No
ItemNo	form	int	No
RowHash	form	byte[]	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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/GL_AutoJournalLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<GL_AutoJournalLinesQuery 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>
  <GL_AutoJournals_RecID>String</GL_AutoJournals_RecID>
  <GL_AutoJournals_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_AutoJournals_RecIDBetween>
  <GL_AutoJournals_RecIDContains>String</GL_AutoJournals_RecIDContains>
  <GL_AutoJournals_RecIDEndsWith>String</GL_AutoJournals_RecIDEndsWith>
  <GL_AutoJournals_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_AutoJournals_RecIDIn>
  <GL_AutoJournals_RecIDLike>String</GL_AutoJournals_RecIDLike>
  <GL_AutoJournals_RecIDStartsWith>String</GL_AutoJournals_RecIDStartsWith>
  <GL_Sets_RecID_Destination>String</GL_Sets_RecID_Destination>
  <GL_Sets_RecID_DestinationBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Sets_RecID_DestinationBetween>
  <GL_Sets_RecID_DestinationContains>String</GL_Sets_RecID_DestinationContains>
  <GL_Sets_RecID_DestinationEndsWith>String</GL_Sets_RecID_DestinationEndsWith>
  <GL_Sets_RecID_DestinationIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Sets_RecID_DestinationIn>
  <GL_Sets_RecID_DestinationLike>String</GL_Sets_RecID_DestinationLike>
  <GL_Sets_RecID_DestinationStartsWith>String</GL_Sets_RecID_DestinationStartsWith>
  <GL_Sets_RecID_Source>String</GL_Sets_RecID_Source>
  <GL_Sets_RecID_SourceBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Sets_RecID_SourceBetween>
  <GL_Sets_RecID_SourceContains>String</GL_Sets_RecID_SourceContains>
  <GL_Sets_RecID_SourceEndsWith>String</GL_Sets_RecID_SourceEndsWith>
  <GL_Sets_RecID_SourceIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Sets_RecID_SourceIn>
  <GL_Sets_RecID_SourceLike>String</GL_Sets_RecID_SourceLike>
  <GL_Sets_RecID_SourceStartsWith>String</GL_Sets_RecID_SourceStartsWith>
  <GL_Sets_SourceDescription>String</GL_Sets_SourceDescription>
  <GL_Sets_SourceDescriptionBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Sets_SourceDescriptionBetween>
  <GL_Sets_SourceDescriptionContains>String</GL_Sets_SourceDescriptionContains>
  <GL_Sets_SourceDescriptionEndsWith>String</GL_Sets_SourceDescriptionEndsWith>
  <GL_Sets_SourceDescriptionIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Sets_SourceDescriptionIn>
  <GL_Sets_SourceDescriptionLike>String</GL_Sets_SourceDescriptionLike>
  <GL_Sets_SourceDescriptionStartsWith>String</GL_Sets_SourceDescriptionStartsWith>
  <ItemNo>0</ItemNo>
  <ItemNoBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoBetween>
  <ItemNoGreaterThan>0</ItemNoGreaterThan>
  <ItemNoGreaterThanOrEqualTo>0</ItemNoGreaterThanOrEqualTo>
  <ItemNoIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>0</d2p1:int>
  </ItemNoIn>
  <ItemNoLessThan>0</ItemNoLessThan>
  <ItemNoLessThanOrEqualTo>0</ItemNoLessThanOrEqualTo>
  <ItemNoNotEqualTo>0</ItemNoNotEqualTo>
  <PostingDue>0001-01-01T00:00:00</PostingDue>
  <PostingDueBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </PostingDueBetween>
  <PostingDueGreaterThan>0001-01-01T00:00:00</PostingDueGreaterThan>
  <PostingDueGreaterThanOrEqualTo>0001-01-01T00:00:00</PostingDueGreaterThanOrEqualTo>
  <PostingDueIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </PostingDueIn>
  <PostingDueLessThan>0001-01-01T00:00:00</PostingDueLessThan>
  <PostingDueLessThanOrEqualTo>0001-01-01T00:00:00</PostingDueLessThanOrEqualTo>
  <PostingDueNotEqualTo>0001-01-01T00:00:00</PostingDueNotEqualTo>
  <Reason>String</Reason>
  <ReasonBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReasonBetween>
  <ReasonContains>String</ReasonContains>
  <ReasonEndsWith>String</ReasonEndsWith>
  <ReasonIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ReasonIn>
  <ReasonLike>String</ReasonLike>
  <ReasonStartsWith>String</ReasonStartsWith>
  <RecID>String</RecID>
  <RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDBetween>
  <RecIDContains>String</RecIDContains>
  <RecIDEndsWith>String</RecIDEndsWith>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDIn>
  <RecIDLike>String</RecIDLike>
  <RecIDStartsWith>String</RecIDStartsWith>
  <RowHash>AA==</RowHash>
</GL_AutoJournalLinesQuery>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfGL_AutoJournalLines7kRqkrSv 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:GL_AutoJournalLines>
      <d2p1:_x003C_GL_AutoJournals_RecID_x003E_k__BackingField>String</d2p1:_x003C_GL_AutoJournals_RecID_x003E_k__BackingField>
      <d2p1:_x003C_GL_Sets_RecID_Destination_x003E_k__BackingField>String</d2p1:_x003C_GL_Sets_RecID_Destination_x003E_k__BackingField>
      <d2p1:_x003C_GL_Sets_RecID_Source_x003E_k__BackingField>String</d2p1:_x003C_GL_Sets_RecID_Source_x003E_k__BackingField>
      <d2p1:_x003C_GL_Sets_SourceDescription_x003E_k__BackingField>String</d2p1:_x003C_GL_Sets_SourceDescription_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_PostingDue_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_PostingDue_x003E_k__BackingField>
      <d2p1:_x003C_Reason_x003E_k__BackingField>String</d2p1:_x003C_Reason_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
    </d2p1:GL_AutoJournalLines>
  </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>
</QueryResponseOfGL_AutoJournalLines7kRqkrSv>