Rest API wont display information from PostgreSQL

Q&A
1

I followed the steps on here https://github.com/Bonitasoft-Community/rest-api-sql-data-source and somehow i was able to compile the maven from command line and have the zip created , however i noticed some few changes (Judging by what i have and what is on here hence i decided to talk about it here )

Now I run the maven command (After i have edited the several files which look like this ) this happens to be the configuration where i would run the Sql queries from (datasource.properties)

I do something like this
File1

Now what the worry is is that when i do everything i am wondering why i pass the query Id and i get this instead

img2

I started to wonder why and where i missed my step. Please do help me as soon as possible I have also uploaded the restapi resource and .sql file and they can be found here

https://www.sendspace.com/file/b15z5b

How do i get this to work?

2

As explain in the error message a parameter in your URL is missing. HTTP GET request parameters are provided in the URL and separated using &. Here is an example: http://{ip}:{port}/bonita/API/extension/sql?queryId=getPersonnalInformation&userId=22

Providing queryId parameter is mandatory and depending on your query some additional parameters might be required (such as userId in your example).