Forum Discussion

softech's avatar
softech
Guide
2 years ago

curl with space

i am trying to do this  with curl

the URL that work is this:

https://productioncommunity.ppp.com/api/2.0/search?q=SELECT messages.count(*), solutions_authored.count(*) FROM users WHERE id = '62890'

 

or this 

https://productioncommunity.ppp.com/api/2.0/search?q=SELECT%20login,%20messages.count(*),%20kudos_received.sum(weight),%20solutions_authored.count(*)%20FROM%20users%20WHERE%20id%20=%20%62890%27

 

 

I am trying to use a very basic batch file with curl and try to do this

 

curl https://productioncommunity.ppp.com/api/2.0/search?q=SELECT%20login,%20messages.count(*),%20kudos_received.sum(weight),%20solutions_authored.count(*)%20FROM%20users%20WHERE%20id%20=%20%62890%27

 

 

but it gives me error

{"status":"error","message":"Invalid query syntax","data":{"type":"error_data","code":603,"developer_message":"","more_info":""},"metadata":{}}-

 

Any suggestion what to do ?  I am trying to do some very basic data collection using this URL for different id.  Welcome for any suggestion

 

 

  • The error code that you are receiving is 603, which is 603 Error 'Access Denied' error. Authentication is successful but user doesn't have sufficient permission to call this API. Additional permissions may need to be assigned to the user role.

    Try giving the user you are using permission to make these calls.

1 Reply

  • The error code that you are receiving is 603, which is 603 Error 'Access Denied' error. Authentication is successful but user doesn't have sufficient permission to call this API. Additional permissions may need to be assigned to the user role.

    Try giving the user you are using permission to make these calls.