Discussions

Ask a Question

DATABASE_VERSION_MISMATCH Error

I have some code that I was running last week that worked fine, but now I'm getting the DATABASE_VERSION_MISMATCH (ErrorMessage': 'Requests to the instance Preview JLL MES NA cannot be processed by this URI') error. Our staging instance was recently updated to 9.8.283 and I seem to be getting this error after the update. I'm using the https://am-ce98a.corrigo.com/api/v1 to send requests to. I also tried exicuting a command (GetCompanyWsdkUrlCommand) to discover the url, but I'm also getting the same DATABASE_VERSION_MISMATCH error. Any thoughts or help would be great. Thanks.

Error from Corrigo API when adding time to a work order

We are getting the following error when adding time to a work order via the API: could not load an entity: [Corrigo.BO.Employee.NhEmployee#369] [SQL: SELECT nhemployee0_.Id as id1_134_0_, nhemployee0_.ConcurrencyId as concurrencyid2_134_0_, nhemployee0_.IsRemoved as isremoved3_134_0_, nhemployee0_.Uidx as uidx4_134_0_, nhemployee0_.DisplayAs as displayas5_134_0_, nhemployee0_.FirstName as firstname6_134_0_, nhemployee0_.LastName as lastname7_134_0_, nhemployee0_.RoleId as roleid8_134_0_, nhemployee0_.AllCommAccess as allcommaccess9_134_0_, nhemployee0_.LanguageId as languageid10_134_0_, nhemployee0_.LocaleId as localeid11_134_0_, nhemployee0_.ActorTypeId as actortypeid12_134_0_, nhemployee0_.Login as login13_134_0_, nhemployee0_.DtPwdChange as dtpwdchange14_134_0_, nhemployee0_.WonInvitedOn as woninvitedon15_134_0_, nhemployee0_.Instructions as instructions16_134_0_, nhemployee0_.WonMemberId as wonmemberid17_134_0_, nhemployee0_.WonLocationId as wonlocationid18_134_0_, nhemployee0_.WonServiceRadius as wonserviceradius19_134_0_, nhemployee0_.IsElectronicPayment as iselectronicpayment20_134_0_, nhemployee0_.WonStatusID as wonstatusid21_134_0_, nhemployee0_.LabelID as labelid22_134_0_, nhemployee0_.IsFreeText as isfreetext23_134_0_, nhemployee0_.WonRadiusType as wonradiustype24_134_0_, nhemployee0_.Pwd as pwd25_134_0_, nhemployee0_.Number as number26_134_0_, nhemployee0_.JobTitle as jobtitle27_134_0_, nhemployee0_.FederalId as federalid28_134_0_, nhemployee0_.IsInactive as isinactive29_134_0_, nhemployee0_.IsResetPwd as isresetpwd30_134_0_, nhemployee0_.UtcDeviceReset as utcdevicereset31_134_0_, nhemployee0_.OrgID as orgid32_134_0_, nhemployee0_.IsIntApiUser as isintapiuser33_134_0_, nhemployee0_.SkipIpFiltering as skipipfiltering34_134_0_, nhemployee0_.ExternalId as externalid35_134_0_, nhemployee0_.TaxWarnOnly as taxwarnonly36_134_0_, nhemployee0_.BillZero as billzero37_134_0_, nhemployee0_.ProviderTypeID as providertypeid38_134_0_, nhemployee0_.TaxExempt as taxexempt39_134_0_, nhemployee0_.ReportsToID as reportstoid40_134_0_, nhemployee0_.LimitPortfolioID as limitportfolioid41_134_0_ FROM dbo.EmployeeObject nhemployee0_ WHERE nhemployee0_.Id=?] The employees exist in Corrigo and have had time added before. Any ideas? Thanks, Juan

Is there an API method to download documents from Corrigo?

Is there an API method to download documents from Corrigo? For example, we'd like to download and attach to an email a PDF. The PDF is in a work order, in the Documents section. Is there a method to download the document? Thanks Juan

Create work order type of Preventative Maintenance

On the CyrusOne account we are using MCIM to manage our assets and preventative maintenenace. The MCIM software has an interface to Corrigo where it creates work orders. But every work order they create is a Request. They would like the ablity to create a PM type of work order, under certain cercumstances. Is that possible? If possible, what change needs to be made to their payload?
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

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

Can not working with Sandbox

Hi there. I have got an error with sand box. I used your apis in https://documenter.getpostman.com/view/18831016/UVsEWpoM. There are errors when I tried to call your api { "ErrorMessage": "Requests to the instance RDC CE Sandbox cannot be processed by this URI", "ErrorCode": "DATABASE_VERSION_MISMATCH", "TimeStamp": "2022-08-08T03:51:24.3950568Z" } How can I deal with that error ? Thanks

Event Notification/Service/Plugin

We're looking to setup event services to have Corrigo push data to our other internal services when Work Orders are created and then later assigned. In the documentation I can see: "Event Plugins are installed at Corrigo, by Corrigo Integration Services, and they are registered for specific Companies." However I would like further information on the process for setting up these service notifications.

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