Jira API return table name and schema

[Jesus Salvador Montiel Sanchez]

I'm building a small wrapper to automate some tasks and when modifying the API query parameters in a specific way, I get the following 500 error.

SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value FROM dbo.entity_property WHERE (ENTITY_NAME=? AND ENTITY_ID=?) AND (PROPERTY_KEY IN () ) ORDER BY UPDATED, ID (Incorrect syntax near ')'.)

I think there's improper input validation, or perhaps a bug. Has this happened to anyone else? I don't want to display the tables in my application's response.

Im using Jira Data center 10.3.1 with API v2.

[Marc -Devoteam- · Accepted solution]

HI @Jesus Salvador Montiel Sanchez 

Welcome to the community.

It seems you SQL contains an empty property key value.

I think property_key is not defined.

SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, CREATED, UPDATED, json_value FROM dbo.entity_property WHERE (ENTITY_NAME=? AND ENTITY_ID=?) AND (PROPERTY_KEY IN () ) ORDER BY UPDATED, ID (Incorrect syntax near ')'.)

This as far as I can remember on using SQL.

[Jesus Salvador Montiel Sanchez]

Property_key is define via JQL using API, im not using sql, this looks like a bug, but thank you for your time.