Discussions
Setting Due Date on a Work Order via the API
Hi, we have an integration between ServiceNow and Corrigo where facilities related tickets are submitted in ServiceNow which then creates a Work Order in Corrigo and ticket updates in SNOW are sent to the API to update the associated Work Order (eg. comments). There is a requirement to set the Due Date on the Corrigo Work Order when the Due Date on the Requested Item in ServiceNow changes. We engaged with support on this, and the proposed solution required major changes to our existing integration and payloads, and requires several more API calls on top of the 5 or so we already have to make. Being able to set a due date on a Work Order seems like it should not require such extensive changes. How would you recommend we accomplish this with minimal changes to our existing integration.
Need help to filter customer/space record based off of Customer.Number and Spaces.Asset.Name
I've below API call that is not filtering rows based off of Spaces.Asset.Name - In the output I would like to see only one record - for Customer - "TOR02" & Space - "01"
Not getting any reponse while retriving the Invoice details. The value (2476700090) is the Number from the WorkOrder API response
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:int="http://corrigo.com/integration/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Header>
<int:CorrigoNetOptions>
<int:ImposeConcurrencyId>false</int:ImposeConcurrencyId>
<int:UpdateLastModified>false</int:UpdateLastModified>
<int:CanDeleteMissingEntity>false</int:CanDeleteMissingEntity>
<int:LockOnDataRetrieval>Default</int:LockOnDataRetrieval>
</int:CorrigoNetOptions>
</soap:Header>
<soap:Body>
<int:RetrieveMultiple><int:queryExpression xsi:type="int:QueryExpression" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<int:EntityType>Invoice</int:EntityType>
<int:PropertySet xsi:type="int:PropertySet"><int:Properties>
<int:string>*</int:string>
</int:Properties>
</int:PropertySet>
<int:Criteria>
<int:Filters>
<int:FilterExpression>
<int:Conditions>
<int:ConditionExpression>
<int:PropertyName>Number</int:PropertyName>
<int:Operator>In</int:Operator>
<int:Values>
<int:anyType xsi:type="xsd:string">2476700090</int:anyType>
</int:Values>
</int:ConditionExpression>
</int:Conditions>
</int:FilterExpression>
</int:Filters>
</int:Criteria>
<int:Distinct>true</int:Distinct>
</int:queryExpression></int:RetrieveMultiple>
</soap:Body>
</soap:Envelope>
could not get any info for invoice information
could not get the response back getting empty
Payload:
WO Action Log
Due By Modifed action records the From/To date time in the Comment. Although this seems to be a system generated text, it has multiple variants -- language and date formats.
Question on update command on API
There have been attempts to utilize the update command via the integration, there is a failed call error. One example of the command they have used is provided below. Please assist on the issue
Facing this issue intermittently - Unable to cast object of type 'generatedProxy_2' to type 'Abm.Corrigo.SoapApi.CorrigoService'.
"Microsoft.Azure.WebJobs.Host.FunctionInvocationException : Exception while executing function: publish ---> System.InvalidCastException : Unable to cast object of type 'generatedProxy_2' to type 'Abm.Corrigo.SoapApi.CorrigoService'.
at System.Runtime.CompilerServices.CastHelpers.ChkCastAny(Void* toTypeHnd,Object obj)
at System.Reflection.DispatchProxy.CreateT,TProxy
at System.ServiceModel.Channels.ServiceChannelProxy.CreateProxy[TChannel](MessageDirection direction,ServiceChannel serviceChannel)
at System.ServiceModel.Channels.ServiceChannelFactory.CreateProxy[TChannel](MessageDirection direction,ServiceChannel serviceChannel)
at System.ServiceModel.Channels.ServiceChannelFactory.CreateChannel[TChannel](EndpointAddress address,Uri via)
at System.ServiceModel.ChannelFactory1.CreateChannel(EndpointAddress address,Uri via) at System.ServiceModel.ClientBase1.get_Channel()
at Abm.Corrigo.SoapApi.CorrigoServiceClient.Abm.Corrigo.SoapApi.CorrigoService.LogInStatusAsync(LogInStatusRequest request) at e:\azagent\A1_work\62\s\src\building-blocks\corrigo-api-service\Connected Services\Abm.Corrigo.SoapApi\Reference.cs : 27731
at async Abm.Corrigo.Integration.BuildingBlocks.ApiService.CorrigoService.IsLoggedIn() at e:\azagent\A1_work\62\s\src\building-blocks\corrigo-api-service\CorrigoService.cs : 234
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at async Abm.Corrigo.Integration.BuildingBlocks.ApiService.CorrigoService.TryLogin() at e:\azagent\A1_work\62\s\src\building-blocks\corrigo-api-service\CorrigoService.cs : 249
SOAP Integration iis not working
Hi Team,
Corrigo SNOW Integration
Corrigo SNOW integration giving error - "{"ErrorMessage":"'body' field is null or empty","ErrorCode":"EMPTY_INPUT_PARAMETER","TimeStamp":"2024-10-01T18:17:10.2075206Z"}" , while sending a request to create work order for Princeton and Wilmington sites, specifically while sending task as "Install".