API SQL Access

  • 26 June 2019
  • 1 reply

I have a query (SELECT * FROM application_geo_rev_shares WHERE application_id in (‘59c4e84718776d7228003349’))

I am trying to run that with more app IDs, but I cannot get it to work on the try it out site. I want to use run_sql_query(), but plugging the above in as the slug does not return any results, just an error. I have a different log in for SQL queries, a different client and secret ID. I know the ID works, but I get a not found error.

Do you have any examples or ideas on how I can correctly build this slug?

1 reply

Userlevel 7
Badge +1

Ended up talking to you over email!

You have to create_sql_query first, to get a “slug” that’s a alphanumeric string, and then plug that into the run_sql_query endpoint.