Discussions
updating pay rates and currencies values
With your help I was able to pull the pay rates and currencies. I can update the PayRate values, but not the Currencies.
Using a PUT with the Employee entity, the body below will update the "IsDefault" value for the PayRates for a single Employee, but it does not update the Rate for that same Currencies entry. It also does not generate an error.
I can update the Currencies directly using a PUT with the UserPayRateMoneyValues entity, but I would prefer to update them (all of them for a single employee) in a single PUT call to the Employee entity if that's possible.
{
"Properties":["Lastname","PayRates.IsDefault","PayRates.Currencies.Rate"],
"Entity": {
"ID":"768",
"Lastname":"test3",
"PayRates":[{"ID":"1460","IsDefault":"true","Rate":5.55}]
}
}
Posted by Jon Huneycutt 2 months ago
Unable to create a WO when matching the sample.
I have the following request to create a WorkOrder. It matches very closely to the example WoCreateCommand1 here: <https://documenter.getpostman.com/view/19494308/UVz1NBwd>
{
"Command" : {
"WorkOrder" : {
"Items" : [
{
"Asset" : {
"Id" : *redacted*
},
"Task" : {
"Id" : _redacted_
}
}
],
"Contactid": _redacted_,
"TypeCategory" : 4,
"SubType" : {
"Id" : 262
},
"Customer" : {
"Id" : _redacted_
}
},
"ComputeSchedule" : true
},
"RequestId" : "TST000",
"Comment": "Created for manual API test"
}
However I get the following error:
{
"ErrorMessage": "{!{Service Request}!} must have contact information defined",
"ErrorCode": "BUSINESS_LOGIC_ERROR",
"TimeStamp": "2024-01-19T21:16:21.1185045Z",
"RequestId": "TST000"
}
This seems to involve specific configuration of the environment I'm calling from the error name. Is there something else I'm missing?
The company I am calling is "Stage KHOV"
Posted by Yiannis Philipopoulos 2 months ago
Determine if an Employee is suspended
In Corrigo you can suspend an employee.
I don't see "Status" or "IsSuspended" or anything like that in the properties of the Employee entity.
Is that exposed somewhere that I just can't see?
Posted by Jon Huneycutt 2 months ago
Corrigo to PowerBI
We currently have several PowerBI dashboards that we map Corrigo data excel sheets too. Is there a way to integrate Corrigo to PowerBI through an API to pull live data? Or would all of the Corrigo data need to go to our organizations data lake/warehouse and then connect to a PowerBI?
Posted by Gabriel Garcia 2 months ago
Amazon S3 credentials for integrated third party applications
We were able to successfully connect our third party application through the provided Corrigo APIs. We succsfully pulled in asset data but we cant retrieve any documents on these assets. Corrigo stores these files in a separate amazon s3 warehouse, and when we try to connect it says we have invalid credentials.
How would we get these credentials or is there some guidance you can provide?
thanks
Posted by Gabriel Garcia 2 months ago
Resolving the name of a Customer Group (non-billing account) from a CustomerGroupId
Hi,
Thanks for the great support provided by this forum.
I am still struggling with one issue - getting the Customer Group name from a CustomerGroupId result.
I'm hoping you can point me in the right direction.
Using the GroupsBridge with the Customer Entity, I can get a list of CustomerIds and related CustomerGroupIds.
I can use the Customer entity to resolve the Customer name.
However, I can't yet find how to resolve the name of the Customer Group(s) linked to the customer.
For example, in the following result, where can I find the NAME of the Customer Group that is CustomerGroupId = 1434?
(Note, IsBillingaccount is false)
```
{
"Data": {
"GroupsBridge": [
{
"CustomerId": 3285,
"CustomerGroupId": 1434,
"IsBillingAccount": false,
"IsParentRemoved": false,
"Id": 9779
}
],
"ConcurrencyId": 6,
"Id": 3285
}
},
```
The code used to get this sample response (one of many returned) is run using the Query API against the Customer Entity, and is:
{
"QueryExpression": {
"Criteria": {
"Conditions": \[
{
"PropertyName": "Id",
"Operator": "GreaterOrEqual",
"Values": [
"0"
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"GroupsBridge.*"
]
},
"Count": 4000,
"FirstResultIndex": 1}
}
}
Thanks for any help you can provide.
Posted by Graham Byars 3 months ago
Can WoCreateCommand be used to create historical Work Orders?
I'd like to create WOs that are** already completed**, and without having to call all the required commands to assign, pickup and complete?
Posted by David Baldi 3 months ago
Resolving Customer Group
Hi,
I'm looking just to confirm my understanding of how to esolve Customer Group for any customer.
As far as I can see, Billing Account entity holds the details of each customers' Billing Account and their Customer Group.
This links to Customer Entity via the LinkCustomer&Group Entity.
In order to do the correct filtering, am I right in saying that:
BillingAccount.IsBillAcct = True gives the billing accounts
BillingAccount.IsBillAcct = False gives the customer group ?
Thank you for checking and confirming/correcting
Posted by Graham Byars 3 months ago
Proposal endpoint
Hello,
Is there any way to update proposal amount? (I know it cannot be updated directly as it returned error message saying the Proposal.Amount property can't be updated).
If not, is there any way to delete or reject a proposal via API?
Posted by James 3 months ago
Getting user/employee payrate lists and values
We’re trying to create a process to update each Corrigo user’s pay rate list with their rate from ADP.
Right now I’m just trying to retrieve that information.
1. I can get the necessary info from ADP.
2. I can get a list of users with the Employee Entity.
3. I can get a list of Pay Rates for each LaborCodeID assigned to them with the UserPayRate Entity.
4. And I can get a list of dollar values (for each of those user payrates I assume) with the UserPayRateMoneyValue Entity.
However, I can’t seem to figure out how to relate those money values to a specific payrate and/or user.
The API reference says the Employee Entity returns data that includes a PayRates element reference that I assume is a list of payrates and their associated money value ids, but when I query the Employee Entity it does not return a PayRates element.
Am I correct in assuming the connection information for payrate values to payrates for employees is in the Employee.PayRates data element?
Why am I not getting that element in my API call? I first assumed it was because the user ID associated with the API Integration did not have it, so I added “Admin – All Scope”, “Admin – Users”, “Permissions – All Users”, and “Manage Users” to the wSDK role, which is assigned to that user. That did not seem to help.
Posted by Jon Huneycutt 3 months ago