Getting Cost Objects for all users via API.

[BenStaples]

Hello,

I have been following the Spend Extension v4.1 documentation where it talks about the ApproverLimit Extension (link bellow) .  While the example given for a single user works and returns the costObjectApprover list however the example for all users gives me a 400 bad request.  Here is the example from documentation:

GET /profile/spend/v4.1/Users?filter=urn:ietf:params:scim:schemas:extension:spend:2.0:ApproverLimit:authorizedApprover[approvalType eq \"report\" and approvalGroup eq \"XYZ\"]

 https://developer.concur.com/api-reference/user-provisioning/spend/v4.1.spend-user-retrieval.html#ap...

I also I attempted to get the costObjects for all approvalGroups for each user, same error:

GET /profile/spend/v4.1/Users?filter=urn:ietf:params:scim:schemas:extension:spend:2.0:ApproverLimit:authorizedApprover[approvalType eq \"report\"]

What am I messing up? Is this the best way to get the data via API?

[KevinD]

@BenStaples I've reached out to a colleague about this. 

In the mean time, what is it exactly you are wanting to see? I'm asking as there might be another way to achieve what you want.

[navneetnair]

Hi Kevin, this is the exact issue we are facing too. I need to iterate through all users that have config for a specific group via the 4.1 Spend API and was trying to use the URI per documentation below:

GET /profile/spend/v4.1/Users?filter=urn:ietf:params:scim:schemas:extension:spend:2.0:ApproverLimit:authorizedApprover[approvalType eq \"report\" and approvalGroup eq \"XYZ\"]

Just like Ben, I get the 400 Bad request error. 

Making a report like you suggest in your last response to this thread is not an option for me. I only can work with an OData response. 

Any hep you can give me would be greatly appreciated! 

Thanks,
Navneet.

[KevinD]

@navneetnair unfortunately, I do no work with APIs so I won't be of much help. Is the company you work for a Certified Concur Partner? 

[BenStaples]

@KevinD Our Goal is is to retrieve and then update the Cost Object Approver List in the Authorised Approvers Section of the Workflows for Concur Expense.

Updating I have achieved through the provisioning bulk API Endpoint

/profile/v4/Bulk/

 We just need to know what is in concur so we know what to add, update and delete.

[KevinD]

@BenStaples okay, so you want to see a list of your Authorized Approvers. I'm taking it you also want to see what their approval limits are as well, is that correct? If so, you can use Cognos reporting to get the full list of your authorized approvers and their limits. It is an easy report to build and run. That way you can see the entire list all in one easy to read report. It can be in Excel, HTML, PDF or XML formats. 

Let me know if this is a possible solution for you.