Discussions
Error using query endpoint
When I used Query API, I get an error message getting the list of WorkOrder Custom Fields,
it looks like some issue in using ActoryType in condition, I tried ObjectTypeId = “WO” , it returns
{
"ErrorMessage": "Input string was not in a correct format.",
"ErrorCode": "BUSINESS_LOGIC_ERROR",
"TimeStamp": "2022-02-23T20:39:32.1179262Z"
}
and ObjectTypeId = “13”, it returns empty response.
request POST 'https://am-ce97c.corrigo.com/api/v1/query/CustomField2' \
--header 'CompanyName: Corrigo Demo' \
--header 'Authorization: Bearer xxx
"QueryExpression":
{
"Criteria": {
"Conditions": [
{
"PropertyName": "ObjectTypeId",
"Operator": "Equal",
"Values": ["WO"]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": { "Properties" : ["*", "Descriptor.*"]},
"Count": 50 ,
"FirstResultIndex": 0
}
}
Posted by David Baldi about 2 years ago
examples in GET (Retrieve) section are wrong
examples in GET (Retrieve) section of documentation are wrong. see here <https://developer.corrigo.com/reference/get>
Posted by david shi 11 months ago
API to fetch related module data to create a WO
We are trying to build a 2 way integration between Facilio and Corrigo for Workorder Module .
Inorder to achieve the same , we need to maintain a mapping of certain attributes in Facilio ( such as customer , property etc) .
Where can we find the API's to fetch the related data that has to be maintained or mapped to create a Work Order in Corrigo (such as the following):
Customer
Category
Subcategory
Task
Priority
Property
Asset
Posted by Dhinesh Kumar over 1 year ago
Inventory Management via REST
Hi,
Could you provide some examples of updating inventory via the REST API? Specifically, making adjustments by product and stock location.
Thanks!
Kellie
Posted by Kellie almost 2 years ago
Approver List
We successfully created some "purchase" proposals via API. But we just found we only can get their status in query. Is there a way to get the "Approver List" details of a proposal?
Posted by James 6 months ago
How to get the space associated with an equipment/asset
Is there any API to retrieve the Space associated with an equipment/asset under a building?
Interested in knowing how corrigo exposes the relationship between equipment and the space where this equipment belong/exists under a building.
Posted by sudha almost 2 years ago
Pull Internal Cost Line Items
Is their a model or method to pull / update / add internal cost line items?
If so, could you provide an example
Posted by Jason May over 1 year ago
Entity Relationship Diagram (ERD)
Hi. Is there an ERD available for the Corrigo API?
Typically, it would include more details such as table relationships (one-to-one, one-to-many, etc.), primary/foreign keys for referential integrity, data types and more laid out in a visual diagram.
The "Data Model of Entities" page in the API Developer site either doesn't provide all of those details or not consistently. For example, the [WorkOrder] table has a [Priority] field with a note to reference the [WoPriority] table. However, it doesn’t specify which field has the relationship and whether it’s a one-to-one/many.
Another example is the String data type. It is listed for some fields but doesn’t disclose whether there’s a character limit or it’s a max string type.
Posted by Matthew Rodriguez about 1 year ago
Updating Internal Cost Status
I'm able to pull internal cost information (specifically the Internal Cost Status and it's ID).
I would like to be able to update it via the API. But I'm having some issues getting it to update. Here is my example code, let me know what I'm doing wrong or provide a sample code on how to update internal cost status.
cost_testing_url = 'https://am-ce98a.corrigo.com/api/v1/base/WorkOrderCost'
update_ic_status = {
'Entity': {
'Id': 738156,
'Items': [
{
'WoId': 738156,
'CostStatusId': 3,
'Comment': 'MES Fuel Surcharge Added via Alteryx',
'TypeId': 'Cost',
'CostCategory': 'SpotPurchase'
}
]
},
'Properties': ['Id', 'Items.Id', 'Items.*']
}
update_ic_status_request = requests.put(cost_testing_url, headers=headers, data=json.dumps(update_ic_status))
When running this I'm getting the following error:
{'ErrorMessage': 'CostCategory is a required field.',
'ErrorCode': 'ERROR_CODE_1',
'TimeStamp': '2022-07-21T22:03:28.0100979Z'}
If you could please provide sample code on how to update internal cost status, that would be great.
Posted by Jason May over 1 year ago
Error updating customer
When trying to update a customer immediately following a get, I receive the following error:
{"ErrorMessage":"Data was already modified by another user.","ErrorCode":"ERROR_CODE_6","TimeStamp":"2022-06-18T18:12:18.8813529Z"}
What is the cause of this error and how can I fix it?
Posted by Wade Burdette almost 2 years ago