I’ve installed v7.10 on Windows and am having trouble trying to get an access token, I’m getting an error that an authorization header should be in the request, which isn’t necessary according to the documentation. I’m using Postman to perform the test.
I have added this URL rewrite rule to the web.config as hinted by the documentation:
But now I get this error response that the password grant type isn’t supported:
{
"error": "unsupported_grant_type",
"message": "The authorization grant type is not supported by the authorization server.",
"hint": "Check the `grant_type` parameter"
}
The request has to be sent using either the “form-data” or “x-www-form-encoded” option, not with the “raw” option, with each item as its own key/value pair.
suitecrm.log shows this error (I’ve shortened the access_token and column name value for readability/security):
Mon Feb 26 22:03:53 2018 [10360][1][FATAL] Error running count query for OAuth2Tokens List: Query Failed: SELECT count(*) c FROM oauth2tokens LEFT JOIN users jt0 ON oauth2tokens.modified_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON oauth2tokens.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where (access_token = "f91c........b15f") AND oauth2tokens.deleted=0::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid column name 'f91c........b15f'.
Mon Feb 26 22:03:53 2018 [10360][1][FATAL] [ERROR] Database failure. Please refer to suitecrm.log for details.