Endpoint

<hostname>/api/v1/ideas

Columns

The IDEAS table contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type
ID* BigInt
ASSIGNED​_TO​_USER VarChar(64)
CATEGORIES​_CREATED​_AT Timestamp(3)
CATEGORIES​_ID BigInt
CATEGORIES​_NAME VarChar(64)
CATEGORIES​_PARENT​_ID Integer
COMMENTS​_COUNT Integer
CREATED​_AT Timestamp(9)
CREATED​_BY​_PORTAL​_USER​_CREATED​_AT Timestamp(3)
CREATED​_BY​_PORTAL​_USER​_EMAIL VarChar(64)
CREATED​_BY​_PORTAL​_USER​_ID BigInt
CREATED​_BY​_PORTAL​_USER​_NAME VarChar(64)
DESCRIPTION​_BODY LongVarChar(1024)
DESCRIPTION​_CREATED​_AT Timestamp(9)
DESCRIPTION​_ID VarChar(32767)
ENDORSEMENTS​_COUNT Integer
KEY VarChar(64)
NAME VarChar(184)
PRODUCT​_CREATED​_AT Timestamp(3)
PRODUCT​_ID BigInt
PRODUCT​_NAME VarChar(64)
PRODUCT​_PRODUCT​_LINE Boolean
PRODUCT​_REFERENCE​_PREFIX VarChar(64)
RESOURCE VarChar(87)
SCORE​_FACTS​_ID BigInt
SCORE​_FACTS​_NAME VarChar(64)
SCORE​_FACTS​_VALUE Integer
URL VarChar(85)
WORKFLOW​_STATUS​_COLOR VarChar(64)
WORKFLOW​_STATUS​_COMPLETE Boolean
WORKFLOW​_STATUS​_ID VarChar(32767)
WORKFLOW​_STATUS​_NAME VarChar(64)
WORKFLOW​_STATUS​_POSITION Integer