Discussions

Ask a Question
ANSWERED

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 } }
ANSWERED

examples in GET (Retrieve) section are wrong

examples in GET (Retrieve) section of documentation are wrong. see here <https://developer.corrigo.com/reference/get>

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
ANSWERED

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
ANSWERED

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?

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.

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
ANSWERED

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.

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.

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?