custom api json to sql

Hi,
we want to use the custom api datasource to get the data needed for our reports. But i noticed that the requests uses json. 
Do you happen to have code to parse that json to an sql statement?
and code to parse the result from the query back to json?
 
regards Jaco