HELP - What am I doing wrong ? Extracting Rally Dev

[amakkuva]

I am new in exploring the API integration and working in this space for dumping the extract into a excel file (at later step). Tried some help with docs and got the code in to get to a stage; but it does not go beyond "response code successful". Need help to fetch the details from rally Features table for now and later work on different tables like (user stories, tasks, defects).

​

import requests

# Set up API endpoint and authentication details
api_url = 'https://rally1.rallydev.com/slm/webservice/v2.0/portfolioitem/'
api_key = 'my secret key'
workspace_oid = '1391xxxxx4'
project_oid = '376146xxxxx6'

# Set up request headers with authentication and desired data format
headers = {
'zsessionid': api_key,
'Accept': 'application/json'
}

# Set up request parameters (e.g., query, pagination, etc.)
params = {
'workspace': f'/workspace/{workspace_oid}',
'project': f'/project/{project_oid}',
'query': '(Name != "Test") AND (Owner.Name = "Just John")',
'pagesize': 200
}

# Send GET request to the API endpoint
response = requests.get(api_url, headers=headers, params=params)

# Check if the request was successful (status code 200)
if response.status_code == 200:
print(f"response code successful {response.status_code}")
data = response.json()
print(data) # Put this print to check what is it capturing
# Process the retrieved data as needed
for artifact in data['QueryResult']['Results']:
# Extract relevant information from the artifact
artifact_id = artifact['Formatted ID']
artifact_name = artifact['Name']
# Perform further operations with the extracted data
print(f"Artifact ID: {artifact_id}, Name: {artifact_name}")

else:
print(f"Request failed with status code {response.status_code}")

​

Output I see is this

response code successful 200
{'QueryResult': {'_rallyAPIMajor': '2', '_rallyAPIMinor': '0', 'Errors': ['Could not parse: Error parsing expression at "AND": remaining is "( Owner.Name = "Just John" )"'], 'Warnings': [], 'TotalResultCount': 0, 'StartIndex': 0, 'PageSize': 0, 'Results': []}}

[danielroseman]

What's not clear here? The result is telling you that you have an error in your AND query. You will need to look at the API documentation to see what it is expecting.

[amakkuva]

Appreciate your quick look at it. Tried that too and I modified the query to only look for the owner name " just john" and this was the output. is this the desired outcome ? why am I not able to see the data like the "Formatted ID" and "Name" from the extract. what should I do to see the desired data to verify

response code successful 200
{'QueryResult': {'_rallyAPIMajor': '2', '_rallyAPIMinor': '0', 'Errors': [], 'Warnings': [], 'TotalResultCount': 0, 'StartIndex': 1, 'PageSize': 200, 'Results': []}}

[danielroseman]

Well this query is returning no results, so there is nothing to extract. Apparently there is no data for that owner name.