Rally - WSAPI: REST Query on User record failing due to Case sensitivity

Products

• CA Agile Central SaaS (Rally)

Issue/Introduction

When running a REST GET query to retrieve Rally users "objectid" case match is not working.

Many times this is failing because the email address that is sent in the REST call is not an exact case match to the email address of the user within Rally.

Example:  https://rally1.rallydev.com/slm/webservice/v2.0/user?query=(EmailAddress = [email protected])&fetch=ObjectID

This returns the object id for the user.

Example:  https://rally1.rallydev.com/slm/webservice/v2.0/user?query=(EmailAddress = [email protected])&fetch=ObjectID

This does not return the object id because the user email in Rally is "[email protected]". 

Notice the first.last is lower case.

 

Cause

If the attribute is contained within quotes then it will need to be an exact case match as our API is interpreting this as a literal match.  If the attribute is using a contain or something similar then the case match is not necessary.

Environment

Component : AGILE CENTRAL

Resolution

Instead of using an equals (=) operator in the query, use a contains operator:

https://rally1.rallydev.com/slm/webservice/v2.0/user?query=(EmailAddress CONTAINS "[email protected]")

If the attribute is contained within quotes,  it will need to be an exact case match as our API is interpreting this as a literal match.  If the attribute is using a contain or something similar then the case match is not necessary.

Additional Information

capitalization; agile central; rally; wsapi; web services api, api call, query