JiwaAPI

<back to all web services

JB_EstimateJournalSetLinesQuery

Requires Authentication
JB_EstimateJournalSetLinesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
JB_JobStages_RecIDquerystringNo
JB_JobStages_RecIDStartsWithquerystringNo
JB_JobStages_RecIDEndsWithquerystringNo
JB_JobStages_RecIDContainsquerystringNo
JB_JobStages_RecIDLikequerystringNo
JB_JobStages_RecIDBetweenquerystring[]No
JB_JobStages_RecIDInquerystring[]No
GL_Main_RecIDquerystringNo
GL_Main_RecIDStartsWithquerystringNo
GL_Main_RecIDEndsWithquerystringNo
GL_Main_RecIDContainsquerystringNo
GL_Main_RecIDLikequerystringNo
GL_Main_RecIDBetweenquerystring[]No
GL_Main_RecIDInquerystring[]No
TransactionDatequeryDateTime?No
TransactionDateGreaterThanOrEqualToqueryDateTime?No
TransactionDateGreaterThanqueryDateTime?No
TransactionDateLessThanqueryDateTime?No
TransactionDateLessThanOrEqualToqueryDateTime?No
TransactionDateNotEqualToqueryDateTime?No
TransactionDateBetweenqueryDateTime[]No
TransactionDateInqueryDateTime[]No
Quantityquerydecimal?No
QuantityGreaterThanOrEqualToquerydecimal?No
QuantityGreaterThanquerydecimal?No
QuantityLessThanquerydecimal?No
QuantityLessThanOrEqualToquerydecimal?No
QuantityNotEqualToquerydecimal?No
QuantityBetweenquerydecimal[]No
QuantityInquerydecimal[]No
UnitCostquerydecimal?No
UnitCostGreaterThanOrEqualToquerydecimal?No
UnitCostGreaterThanquerydecimal?No
UnitCostLessThanquerydecimal?No
UnitCostLessThanOrEqualToquerydecimal?No
UnitCostNotEqualToquerydecimal?No
UnitCostBetweenquerydecimal[]No
UnitCostInquerydecimal[]No
UnitChargequerydecimal?No
UnitChargeGreaterThanOrEqualToquerydecimal?No
UnitChargeGreaterThanquerydecimal?No
UnitChargeLessThanquerydecimal?No
UnitChargeLessThanOrEqualToquerydecimal?No
UnitChargeNotEqualToquerydecimal?No
UnitChargeBetweenquerydecimal[]No
UnitChargeInquerydecimal[]No
RemarkquerystringNo
RemarkStartsWithquerystringNo
RemarkEndsWithquerystringNo
RemarkContainsquerystringNo
RemarkLikequerystringNo
RemarkBetweenquerystring[]No
RemarkInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
HR_Staff_RecIDquerystringNo
HR_Staff_RecIDStartsWithquerystringNo
HR_Staff_RecIDEndsWithquerystringNo
HR_Staff_RecIDContainsquerystringNo
HR_Staff_RecIDLikequerystringNo
HR_Staff_RecIDBetweenquerystring[]No
HR_Staff_RecIDInquerystring[]No
RowHashquerybyte[]No
UnitsquerystringNo
UnitsStartsWithquerystringNo
UnitsEndsWithquerystringNo
UnitsContainsquerystringNo
UnitsLikequerystringNo
UnitsBetweenquerystring[]No
UnitsInquerystring[]No
JB_EstimateLines_RecIDquerystringNo
JB_EstimateLines_RecIDStartsWithquerystringNo
JB_EstimateLines_RecIDEndsWithquerystringNo
JB_EstimateLines_RecIDContainsquerystringNo
JB_EstimateLines_RecIDLikequerystringNo
JB_EstimateLines_RecIDBetweenquerystring[]No
JB_EstimateLines_RecIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
JB_EstimateJournalSetLines Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
JB_JobStages_RecIDformstringNo
GL_Main_RecIDformstringNo
TransactionDateformDateTimeNo
QuantityformdecimalNo
UnitCostformdecimalNo
UnitChargeformdecimalNo
RemarkformstringNo
LastSavedDateTimeformDateTimeNo
HR_Staff_RecIDformstringNo
RowHashformbyte[]No
UnitsformstringNo
JB_EstimateLines_RecIDformstringNo
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/JB_EstimateJournalSetLinesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<JB_EstimateJournalSetLinesQuery 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_Main_RecID>String</GL_Main_RecID>
  <GL_Main_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Main_RecIDBetween>
  <GL_Main_RecIDContains>String</GL_Main_RecIDContains>
  <GL_Main_RecIDEndsWith>String</GL_Main_RecIDEndsWith>
  <GL_Main_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </GL_Main_RecIDIn>
  <GL_Main_RecIDLike>String</GL_Main_RecIDLike>
  <GL_Main_RecIDStartsWith>String</GL_Main_RecIDStartsWith>
  <HR_Staff_RecID>String</HR_Staff_RecID>
  <HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDBetween>
  <HR_Staff_RecIDContains>String</HR_Staff_RecIDContains>
  <HR_Staff_RecIDEndsWith>String</HR_Staff_RecIDEndsWith>
  <HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDIn>
  <HR_Staff_RecIDLike>String</HR_Staff_RecIDLike>
  <HR_Staff_RecIDStartsWith>String</HR_Staff_RecIDStartsWith>
  <JB_EstimateLines_RecID>String</JB_EstimateLines_RecID>
  <JB_EstimateLines_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_EstimateLines_RecIDBetween>
  <JB_EstimateLines_RecIDContains>String</JB_EstimateLines_RecIDContains>
  <JB_EstimateLines_RecIDEndsWith>String</JB_EstimateLines_RecIDEndsWith>
  <JB_EstimateLines_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_EstimateLines_RecIDIn>
  <JB_EstimateLines_RecIDLike>String</JB_EstimateLines_RecIDLike>
  <JB_EstimateLines_RecIDStartsWith>String</JB_EstimateLines_RecIDStartsWith>
  <JB_JobStages_RecID>String</JB_JobStages_RecID>
  <JB_JobStages_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_JobStages_RecIDBetween>
  <JB_JobStages_RecIDContains>String</JB_JobStages_RecIDContains>
  <JB_JobStages_RecIDEndsWith>String</JB_JobStages_RecIDEndsWith>
  <JB_JobStages_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </JB_JobStages_RecIDIn>
  <JB_JobStages_RecIDLike>String</JB_JobStages_RecIDLike>
  <JB_JobStages_RecIDStartsWith>String</JB_JobStages_RecIDStartsWith>
  <LastSavedDateTime>0001-01-01T00:00:00</LastSavedDateTime>
  <LastSavedDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeBetween>
  <LastSavedDateTimeGreaterThan>0001-01-01T00:00:00</LastSavedDateTimeGreaterThan>
  <LastSavedDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeGreaterThanOrEqualTo>
  <LastSavedDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </LastSavedDateTimeIn>
  <LastSavedDateTimeLessThan>0001-01-01T00:00:00</LastSavedDateTimeLessThan>
  <LastSavedDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</LastSavedDateTimeLessThanOrEqualTo>
  <LastSavedDateTimeNotEqualTo>0001-01-01T00:00:00</LastSavedDateTimeNotEqualTo>
  <Quantity>0</Quantity>
  <QuantityBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityBetween>
  <QuantityGreaterThan>0</QuantityGreaterThan>
  <QuantityGreaterThanOrEqualTo>0</QuantityGreaterThanOrEqualTo>
  <QuantityIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </QuantityIn>
  <QuantityLessThan>0</QuantityLessThan>
  <QuantityLessThanOrEqualTo>0</QuantityLessThanOrEqualTo>
  <QuantityNotEqualTo>0</QuantityNotEqualTo>
  <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>
  <Remark>String</Remark>
  <RemarkBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkBetween>
  <RemarkContains>String</RemarkContains>
  <RemarkEndsWith>String</RemarkEndsWith>
  <RemarkIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RemarkIn>
  <RemarkLike>String</RemarkLike>
  <RemarkStartsWith>String</RemarkStartsWith>
  <RowHash>AA==</RowHash>
  <TransactionDate>0001-01-01T00:00:00</TransactionDate>
  <TransactionDateBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransactionDateBetween>
  <TransactionDateGreaterThan>0001-01-01T00:00:00</TransactionDateGreaterThan>
  <TransactionDateGreaterThanOrEqualTo>0001-01-01T00:00:00</TransactionDateGreaterThanOrEqualTo>
  <TransactionDateIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </TransactionDateIn>
  <TransactionDateLessThan>0001-01-01T00:00:00</TransactionDateLessThan>
  <TransactionDateLessThanOrEqualTo>0001-01-01T00:00:00</TransactionDateLessThanOrEqualTo>
  <TransactionDateNotEqualTo>0001-01-01T00:00:00</TransactionDateNotEqualTo>
  <UnitCharge>0</UnitCharge>
  <UnitChargeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitChargeBetween>
  <UnitChargeGreaterThan>0</UnitChargeGreaterThan>
  <UnitChargeGreaterThanOrEqualTo>0</UnitChargeGreaterThanOrEqualTo>
  <UnitChargeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitChargeIn>
  <UnitChargeLessThan>0</UnitChargeLessThan>
  <UnitChargeLessThanOrEqualTo>0</UnitChargeLessThanOrEqualTo>
  <UnitChargeNotEqualTo>0</UnitChargeNotEqualTo>
  <UnitCost>0</UnitCost>
  <UnitCostBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitCostBetween>
  <UnitCostGreaterThan>0</UnitCostGreaterThan>
  <UnitCostGreaterThanOrEqualTo>0</UnitCostGreaterThanOrEqualTo>
  <UnitCostIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:decimal>0</d2p1:decimal>
  </UnitCostIn>
  <UnitCostLessThan>0</UnitCostLessThan>
  <UnitCostLessThanOrEqualTo>0</UnitCostLessThanOrEqualTo>
  <UnitCostNotEqualTo>0</UnitCostNotEqualTo>
  <Units>String</Units>
  <UnitsBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UnitsBetween>
  <UnitsContains>String</UnitsContains>
  <UnitsEndsWith>String</UnitsEndsWith>
  <UnitsIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </UnitsIn>
  <UnitsLike>String</UnitsLike>
  <UnitsStartsWith>String</UnitsStartsWith>
</JB_EstimateJournalSetLinesQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfJB_EstimateJournalSetLines7kRqkrSv 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:JB_EstimateJournalSetLines>
      <d2p1:_x003C_GL_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_GL_Main_RecID_x003E_k__BackingField>
      <d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_JB_EstimateLines_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_EstimateLines_RecID_x003E_k__BackingField>
      <d2p1:_x003C_JB_JobStages_RecID_x003E_k__BackingField>String</d2p1:_x003C_JB_JobStages_RecID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_Quantity_x003E_k__BackingField>0</d2p1:_x003C_Quantity_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Remark_x003E_k__BackingField>String</d2p1:_x003C_Remark_x003E_k__BackingField>
      <d2p1:_x003C_RowHash_x003E_k__BackingField>AA==</d2p1:_x003C_RowHash_x003E_k__BackingField>
      <d2p1:_x003C_TransactionDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_TransactionDate_x003E_k__BackingField>
      <d2p1:_x003C_UnitCharge_x003E_k__BackingField>0</d2p1:_x003C_UnitCharge_x003E_k__BackingField>
      <d2p1:_x003C_UnitCost_x003E_k__BackingField>0</d2p1:_x003C_UnitCost_x003E_k__BackingField>
      <d2p1:_x003C_Units_x003E_k__BackingField>String</d2p1:_x003C_Units_x003E_k__BackingField>
    </d2p1:JB_EstimateJournalSetLines>
  </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>
</QueryResponseOfJB_EstimateJournalSetLines7kRqkrSv>