Solutions

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for this record.
SolutionNumber	String	False	The number of the solution.
SolutionOwner_Id	String	False	The Id of the owner of the solution.
SolutionOwner_Name	String	True	The name of the owner of the solution.
SolutionTitle	String	False	The title of the solution.
Published	Bool	False	Whether the solution is published or not.
Status	String	False	The status of the solution.
ProductName_Id	String	False	The Id of the product concerning this solution.
ProductName_Name	String	True	The name of the product concerning this solution.
No_ofcomments	Int	True	The number of different comments in this solution.
CreatedBy_Id	String	False	The Id of the User who created the record.
CreatedBy_Name	String	True	The name of the user who created the record.
ModifiedBy_Id	String	False	The Id of the User who modified the record.
ModifiedBy_Name	String	True	The name of the User who modified the record.
CreatedTime	Datetime	False	The time when the record was created.
ModifiedTime	Datetime	False	The time when the record was modified.
Tag	String	False	A list of tags related to this record.
Question	String	False	The question which was asked that led to the creating of this solution.
Answer	String	False	The answer given for this solution.
AddComment	String	False	An additional comment give for this solution.
Comments	String	True	A list of comments given in this solution.

Pseudo-Columns

Name	Type	Description
Word	String	Used to search for a specific word in records.
DuplicateCheckFields	String	The field/s to be used for checking in an upsert.
Converted	Boolean	Set to true to return only converted records.
Approved	Boolean	Set to true to return only approved records.
CustomViewId	String	The custom view Id to be used for filtering this record.