Fisheye rest API 'queryasrows' not working with curl

Question

Hi Team, I was trying to run the API using command line, but it is giving error HTTP/1.1 400 Bad Request curl -g --insecure -D- -u xxx:xxx -X GET --data @get.txt -H "Content-Type: application/xml" "https:///rest-service-fe/search-v1/queryAsRows/?query=select revisions where (not in any review and date in [2017-03-16,2017-03-22]) group by changeset return path, revision, csid, author, comment, reviews" Though, the link is working on browser https:///rest-service-fe/search-v1/queryAsRows/?query=select revisions where (not in any review and date in [2017-03-16,2017-03-22]) group by changeset return path, revision, csid, author, comment, reviews This is bit urgent. Please help me with the resolution or where am I doing it wrong ? Thanks, Gunjan Roy

Jeff Thomas · Answer

Hi Gunjan, Can you try the following? curl -g --insecure -D -u xxx:xxx -X GET -H "Content-Type: application/xml" "https:///rest-service-fe/search-v1/queryAsRows/?query=select revisions where (not in any review and date in [2017-03-16,2017-03-22]) group by changeset return path, revision, csid, author, comment, reviews" I made a few changes such as URL encoding the query string and removing the get.txt that was being sent. What is contained in get.txt? You shouldn't need to send any data via a file in this scenario. Cheers, Jeff