JiwaAPI

SM_ActivityBudgetsQuery

**SM_ActivityBudgetsQuery** 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
SM_Activities_RecID	query	string	No
SM_Activities_RecIDStartsWith	query	string	No
SM_Activities_RecIDEndsWith	query	string	No
SM_Activities_RecIDContains	query	string	No
SM_Activities_RecIDLike	query	string	No
SM_Activities_RecIDBetween	query	string[]	No
SM_Activities_RecIDIn	query	string[]	No
SM_Tasks_RecID	query	string	No
SM_Tasks_RecIDStartsWith	query	string	No
SM_Tasks_RecIDEndsWith	query	string	No
SM_Tasks_RecIDContains	query	string	No
SM_Tasks_RecIDLike	query	string	No
SM_Tasks_RecIDBetween	query	string[]	No
SM_Tasks_RecIDIn	query	string[]	No
BudgetedBillingTime	query	decimal?	No
BudgetedBillingTimeGreaterThanOrEqualTo	query	decimal?	No
BudgetedBillingTimeGreaterThan	query	decimal?	No
BudgetedBillingTimeLessThan	query	decimal?	No
BudgetedBillingTimeLessThanOrEqualTo	query	decimal?	No
BudgetedBillingTimeNotEqualTo	query	decimal?	No
BudgetedBillingTimeBetween	query	Nullable<Decimal>[]	No
BudgetedBillingTimeIn	query	Nullable<Decimal>[]	No
BudgetedElapsedTime	query	decimal?	No
BudgetedElapsedTimeGreaterThanOrEqualTo	query	decimal?	No
BudgetedElapsedTimeGreaterThan	query	decimal?	No
BudgetedElapsedTimeLessThan	query	decimal?	No
BudgetedElapsedTimeLessThanOrEqualTo	query	decimal?	No
BudgetedElapsedTimeNotEqualTo	query	decimal?	No
BudgetedElapsedTimeBetween	query	Nullable<Decimal>[]	No
BudgetedElapsedTimeIn	query	Nullable<Decimal>[]	No
BudgetedBillingValue	query	decimal?	No
BudgetedBillingValueGreaterThanOrEqualTo	query	decimal?	No
BudgetedBillingValueGreaterThan	query	decimal?	No
BudgetedBillingValueLessThan	query	decimal?	No
BudgetedBillingValueLessThanOrEqualTo	query	decimal?	No
BudgetedBillingValueNotEqualTo	query	decimal?	No
BudgetedBillingValueBetween	query	Nullable<Decimal>[]	No
BudgetedBillingValueIn	query	Nullable<Decimal>[]	No
LastSavedDateTime	query	DateTime?	No
LastSavedDateTimeGreaterThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeGreaterThan	query	DateTime?	No
LastSavedDateTimeLessThan	query	DateTime?	No
LastSavedDateTimeLessThanOrEqualTo	query	DateTime?	No
LastSavedDateTimeNotEqualTo	query	DateTime?	No
LastSavedDateTimeBetween	query	DateTime[]	No
LastSavedDateTimeIn	query	DateTime[]	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

**SM_ActivityBudgets** Parameters:
Name	Parameter	Data Type	Required
RecID	form	string	No
SM_Activities_RecID	form	string	No
SM_Tasks_RecID	form	string	No
BudgetedBillingTime	form	decimal?	No
BudgetedElapsedTime	form	decimal?	No
BudgetedBillingValue	form	decimal?	No
LastSavedDateTime	form	DateTime	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/SM_ActivityBudgetsQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_ActivityBudgetsQuery 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>
  <BudgetedBillingTime>0</BudgetedBillingTime>
  <BudgetedBillingTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </BudgetedBillingTimeBetween>
  <BudgetedBillingTimeGreaterThan>0</BudgetedBillingTimeGreaterThan>
  <BudgetedBillingTimeGreaterThanOrEqualTo>0</BudgetedBillingTimeGreaterThanOrEqualTo>
  <BudgetedBillingTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </BudgetedBillingTimeIn>
  <BudgetedBillingTimeLessThan>0</BudgetedBillingTimeLessThan>
  <BudgetedBillingTimeLessThanOrEqualTo>0</BudgetedBillingTimeLessThanOrEqualTo>
  <BudgetedBillingTimeNotEqualTo>0</BudgetedBillingTimeNotEqualTo>
  <BudgetedBillingValue>0</BudgetedBillingValue>
  <BudgetedBillingValueBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </BudgetedBillingValueBetween>
  <BudgetedBillingValueGreaterThan>0</BudgetedBillingValueGreaterThan>
  <BudgetedBillingValueGreaterThanOrEqualTo>0</BudgetedBillingValueGreaterThanOrEqualTo>
  <BudgetedBillingValueIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </BudgetedBillingValueIn>
  <BudgetedBillingValueLessThan>0</BudgetedBillingValueLessThan>
  <BudgetedBillingValueLessThanOrEqualTo>0</BudgetedBillingValueLessThanOrEqualTo>
  <BudgetedBillingValueNotEqualTo>0</BudgetedBillingValueNotEqualTo>
  <BudgetedElapsedTime>0</BudgetedElapsedTime>
  <BudgetedElapsedTimeBetween xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </BudgetedElapsedTimeBetween>
  <BudgetedElapsedTimeGreaterThan>0</BudgetedElapsedTimeGreaterThan>
  <BudgetedElapsedTimeGreaterThanOrEqualTo>0</BudgetedElapsedTimeGreaterThanOrEqualTo>
  <BudgetedElapsedTimeIn xmlns:d2p1="http://schemas.datacontract.org/2004/07/System">
    <d2p1:decimal>0</d2p1:decimal>
  </BudgetedElapsedTimeIn>
  <BudgetedElapsedTimeLessThan>0</BudgetedElapsedTimeLessThan>
  <BudgetedElapsedTimeLessThanOrEqualTo>0</BudgetedElapsedTimeLessThanOrEqualTo>
  <BudgetedElapsedTimeNotEqualTo>0</BudgetedElapsedTimeNotEqualTo>
  <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>
  <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>
  <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>
  <SM_Activities_RecID>String</SM_Activities_RecID>
  <SM_Activities_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Activities_RecIDBetween>
  <SM_Activities_RecIDContains>String</SM_Activities_RecIDContains>
  <SM_Activities_RecIDEndsWith>String</SM_Activities_RecIDEndsWith>
  <SM_Activities_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Activities_RecIDIn>
  <SM_Activities_RecIDLike>String</SM_Activities_RecIDLike>
  <SM_Activities_RecIDStartsWith>String</SM_Activities_RecIDStartsWith>
  <SM_Tasks_RecID>String</SM_Tasks_RecID>
  <SM_Tasks_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDBetween>
  <SM_Tasks_RecIDContains>String</SM_Tasks_RecIDContains>
  <SM_Tasks_RecIDEndsWith>String</SM_Tasks_RecIDEndsWith>
  <SM_Tasks_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDIn>
  <SM_Tasks_RecIDLike>String</SM_Tasks_RecIDLike>
  <SM_Tasks_RecIDStartsWith>String</SM_Tasks_RecIDStartsWith>
</SM_ActivityBudgetsQuery>

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

<QueryResponseOfSM_ActivityBudgets7kRqkrSv 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:SM_ActivityBudgets>
      <d2p1:_x003C_BudgetedBillingTime_x003E_k__BackingField>0</d2p1:_x003C_BudgetedBillingTime_x003E_k__BackingField>
      <d2p1:_x003C_BudgetedBillingValue_x003E_k__BackingField>0</d2p1:_x003C_BudgetedBillingValue_x003E_k__BackingField>
      <d2p1:_x003C_BudgetedElapsedTime_x003E_k__BackingField>0</d2p1:_x003C_BudgetedElapsedTime_x003E_k__BackingField>
      <d2p1:_x003C_ItemNo_x003E_k__BackingField>0</d2p1:_x003C_ItemNo_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_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:_x003C_SM_Activities_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Activities_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>
    </d2p1:SM_ActivityBudgets>
  </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>
</QueryResponseOfSM_ActivityBudgets7kRqkrSv>