#define DATA_TABLE "a"                    // (str) Table name
#define DATA_FIELDS "b"                    // (arr) data fields
#define DATA_LIMIT "c"                    // (arr)(nested) You can use = & != !& > <  [["field=val", AND "field<val"], OR "field!=val"]...
#define DATA_NR_FIELDS "d"                // (int)nr_results
#define DATA_ORDER_BY "e"                // (array)[{"f":(str)field, "d":(int)descending}...]

// Root values are ORED, ex:
llList2Json(JSON_ARRAY, [ // Search for charkey of llGetOwner OR id=2
   "charkey="+(string)llGetOwner(), "id=2"
])

// A sub array uses AND
llList2Json(JSON_ARRAY, [ // Search sex = male AND species = cat 
   llList2Json(JSON_ARRAY, ["sex=1","species=cat"])
])

// Get the XOBJ library: https://github.com/JasXSL/JasX-HUD
#include "jasx_hud/_core.lsl" 

default
{
    state_entry()
    {
        // Get JasX ID, and username of owner
        string call = apiTask(
            // Task to get data from a table
            API_GET_DATA, 
            
            // This is the data that gets passed along
            llList2Json(JSON_OBJECT, [
            
                DATA_TABLE, "jfish_users", // We will fetch from the jfish_users table
                
                DATA_FIELDS, llList2Json(JSON_ARRAY, [ // Get ID and username
                    "id", "username"
                ]),
                
                DATA_NR_FIELDS, 3,  // Get the last 3
                
                DATA_ORDER_BY, llList2Json(JSON_ARRAY, [
                    llList2Json(JSON_OBJECT, ["f","id", "d",1])
                ])
            ]), 
            
            "" // Optional callback
        );
        
        sendAPI("", [call]);  // Send the API call here. The first value is an API key you can get on your jasx control panel. It is only needed for private values and SETTING values.
    }
    
    http_response(key id, integer status, list meta, string body){
        
        if(llJsonValueType(body,[]) != JSON_OBJECT)llOwnerSay("Error:\n"+body);
        else{
            
            // There were some messages from the server included, let's output them
            if(llJsonValueType(body, [API_MESSAGES]) != JSON_INVALID){
                list m = llJson2List(llJsonGetValue(body, [API_MESSAGES]));
                while(llGetListLength(m)){
                    llOwnerSay(llList2String(m,0));
                    m = llDeleteSubList(m,0,0);
                }
            }
            
            // Let's check what tasks we got back
            if(llJsonValueType(body, [API_TASKS]) != JSON_INVALID){            
                list d = llJson2List(llJsonGetValue(body, [API_TASKS]));
                while(llGetListLength(d)){
                    string data = llList2String(d,0);
                    d = llDeleteSubList(d, 0,0);
                    
                    integer task = (integer)llJsonGetValue(data, [API_TASK]);
                    string taskData = llJsonGetValue(data, [API_DATA]);
                    string callback = llJsonGetValue(data, [API_CALLBACK]);
                    integer status = (integer)llJsonGetValue(data, [API_STATUS]);
                    
                    // Success! The API call worked!
                    if(status == STATUS_SUCCESS){
                        llOwnerSay((string)task+" was executed successfully!");
                        if(callback != JSON_INVALID)llOwnerSay("Callback: "+callback);
                        if(taskData != JSON_INVALID)llOwnerSay("Data returned: "+taskData);
                        else llOwnerSay("Server returned no data. Perhaps it didn't find anything?");
                    }
                    else{ // There was an error
                        llOwnerSay((string)task+" failed:");
                        if(status == STATUS_FAIL_ACCESS_DENIED)llOwnerSay("Access denied");
                        else if(status == STATUS_FAIL_DATA_MISSING)llOwnerSay("Data fields missing");
                        else llOwnerSay("See messages.");
                    }
                    
                }
            }
            
        }
    }
}