Hi Eric,

Not directly I'm afraid, Marcel has pointed you in the right direction here. You could indeed use SparkRequests in Cloud Code for this. 

//sets the from date to 10 days back from now
var dateFrom = new Date();
dateFrom.setDate(dateFrom.getDate()-10);

//sets the to date to now
var dateTo = new Date();
dateTo.setDate(dateTo.getDate());

//send our ListTransactionsRequest
var request = new SparkRequests.ListTransactionsRequest();
request.dateFrom = getDateString(dateFrom);
request.dateTo = getDateString(dateTo);
request.entryCount = 5;

var response = request.Send();

//display the response in scriptData
Spark.setScriptData("vGoods", response)


//function to correctly format the dates for the request
function getDateString(date){
    
    var dateString = date.toISOString();
    return  dateString.substr(0, dateString.lastIndexOf(".")) + "Z";
    
}

You could also include the "include" field in the request to filter the results. 

Thanks,

Liam

Hi Eric,

You could try using SendRequestAs for this in Cloud Code, this will work the same as above but will return the transaction list for the given playerId.

var request = Spark.sendRequestAs(
    {
    "@class": ".ListTransactionsRequest", 
    "dateFrom": getDateString(dateFrom),
    "dateTo": getDateString(dateTo),
    "entryCount": 10,
    }, playerID);
    
Spark.setScriptData("vGoods", request.transactionList)

It would also use the date function from the code above, let me know if that helps.

Thanks,

Liam

Hi Eric,

By default the results will list the transactions starting with the most recent one first and working backwards, once you have the transactionList array you can sort it however you'd like in the response. For example response.transactionList.reverse() will reverse the list. You can play around with with this until you find something that suits your needs.

Thanks,

Liam