Discussions

Ask a Question
Back to All

Creating work order via API - The Church account in stage

Client created two new Issues using the api and it looks like they were both created successfully in Corrigo stage as C5391660-00034. The work order came thru with correct task, (priority, specialty, expense code) which are all picked at the task level but it did not pick up the correct NTE amount. Question is why? Here are the queries that were executed for C5391660-00034:
// Customer query
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "TenantCode",
"Operator": "Equal",
"Values": [
"5391660-01-01"
]
},
{
"PropertyName": "IsRemoved",
"Operator": "Equal",
"Values": [
"false"
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"id",
"Spaces.Asset.Id",
"Spaces.Asset.Name",
"Workzone.id"
]
},
"Count": 1,
"FirstResultIndex": 0
}
}

// Space query
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "CustomerId",
"Operator": "Equal",
"Values": [
14181
]
},
{
"PropertyName": "IsRemoved",
"Operator": "Equal",
"Values": [
"false"
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"*"
]
},
"Count": 0,
"FirstResultIndex": 0
}
}

// AssetTree query
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "ParentId",
"Operator": "Equal",
"Values": [
2555409
]
},
{
"PropertyName": "Child.Name",
"Operator": "Equal",
"Values": [
"Landscaping"
]
},
{
"PropertyName": "Child.IsOffline",
"Operator": "Equal",
"Values": [
"false"
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"",
"Child.
"
]
},
"Count": 0,
"FirstResultIndex": 0
}
}

// Model query
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "Description",
"Operator": "Equal",
"Values": [
"Grounds - Landscaping (Ext)"
]
},
{
"PropertyName": "Id",
"Operator": "In",
"Values": [
6926
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"Id",
"DisplayAs",
"Description"
]
},
"Count": 0,
"FirstResultIndex": 0
}
}

// Task query
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "ModelId",
"Operator": "Equal",
"Values": [
6926
]
},
{
"PropertyName": "IsRemoved",
"Operator": "Equal",
"Values": [
"false"
]
},
{
"PropertyName": "DisplayAs",
"Operator": "Equal",
"Values": [
"Grass/Lawn/Beds"
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"ModelId",
"DisplayAs"
]
},
"Count": 1,
"FirstResultIndex": 0
}
}