Error while creating new ticket using REST API

You need to look at your problem_type table and check what problem_type_id 6 is and if it is in the deleted state or not.  Most likely it is a problem_type what was deleted.The example appears to be using that problem_type in the ticket creation.

-j_a_catlin

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Thanks for prompting that j_a_catlin

Can you please also point me how do we find the client ID's? So we can easily assign that during the ticket creation.

Thanks!!! 

You should be able to query against the client table for the client_id column.  Depending on how you want to do the lookup to ID the client_ID would be the next major hurdle.  If the ticket is being submitted with an email address associated with it, then you could just use the column email as the filter.  Options that would ideally be used are user_name or email if they are available.

-j_a_catlin

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Thanks Below SQL query worked -

SELECT CLIENT_ID, USER_NAME, FIRST_NAME, LAST_NAME from client where USER_NAME = 'test';