Column name inconsistency when running queries with Rest API.

Question

Hi,

after years of processing csv files I have recently started using RStudio to submit queries to Jira Cloud via the Rest API:

query<-httr::GET( queryArray[i], authenticate( userString,tokenString,'basic'))

I find that column naming varies but I cannot see why e.g I submit 10 queries in quick succession and observe “Time Spent” in some cases or "Time.Spent" in others.

Is there a setting somewhere to ensure consistency?

Thanks.

Louis Mehr · Accepted Answer

Not a Jira bug.  This is an R issue.  In some cases the response is being converted to a dataframe from a matrix.  For some reason "Time Spent" becomes "Time.Spent".