Hi!
I was able to make the API work ok and I linked it to a domain.
All of you have sudo access. Shall we start doing shiny stuff?

I also added colours and continents to country attributes in the DB
I sent an email with the domain :)

Also, when I discovered I forgot continents and colours by continent (added now to DB) I also figured some questions:

• (DONE) Would it be ok to add some simple ifelse statements in plumber code to allow "reporter = all" or "partner = all"? the idea here would be to show a table filtered only by year
• Would it be ok to allow some missing parameters on API calls? (i.e. on table yrpc that is "year, reporter, partner and commodity, probably I don't wanna filter partners and just show all of them)
• What do you think about suitable colours? (important)

All the best !!

@jbkunst @eliocamp
here's the API code, I'll email you a file with the most common queries obtained from pg_stats, which is the only source for analytics as this project does not use trackers or anything.

https://github.com/tradestatistics/plumber-api/blob/master/queries.R#L900
also in package options

Hi !!

The server now has the full DB and I installed both RStudio Server and these R packages as root (so those are available for all users):

• RPostgreSQL
• tidyverse
• jsonlite
• plumber
• glue

The script on this repo was an attempt to run an SQL query and convert the result to JSON. My 1st test was:

> library(plumber)
> api <- plumb("api.R")
Loading required package: DBI
> api$run(port = 8000)
Starting server to listen on port 8000
Running the swagger UI at http://127.0.0.1:8000/__swagger__/

The output returns:

pacha@tradestatistics:~$ curl "http://localhost:8000/echo"
{"msg":["The message is: ''"]}
pacha@tradestatistics:~$ curl "http://localhost:8000/yrpc?y=2015"
["{}"]

while RStudio returns:

Error in postgresqlExecStatement(conn, statement, ...) : 
  RS-DBI driver: (could not Retrieve the result : ERROR:  invalid byte sequence for encoding "UTF8": 0xb9
)
Warning in postgresqlQuickSQL(conn, statement, ...) :
  Could not create execute: 

Can you give me a hand? You can always go to data.local:8787 and open RStudio Server :)

Hi!

I have pushed a decent API draft. I saw here and docker seems to be a suitable method to run the API in the server and then go data.local/api/yr?y=2010&r=chl or whatever from firefox

What do you think about docker and/or other methods?