Search code examples
yodlee

Get all user transactions with executeUserSearchRequest


I'm using the Yodlee REST API and am trying to retrieve all user transactions in giving dates.

When calling executeUserSearchRequest with the following params, I get only 13 transactions instead of more.

transactionSearchRequest.containerType=all
transactionSearchRequest.higherFetchLimit=500
transactionSearchRequest.lowerFetchLimit=1
transactionSearchRequest.resultRange.startNumber=1
transactionSearchRequest.resultRange.endNumber=500
transactionSearchRequest.searchClients.clientId=1
transactionSearchRequest.searchClients.clientName=DataSearchService
transactionSearchRequest.searchFilter.currencyCode=ILS
transactionSearchRequest.ignoreUserInput=true
transactionSearchRequest.searchFilter.transactionSplitType=ALL_TRANSACTION
transactionSearchRequest.searchFilter.postDateRange.fromDate=01-01-2014
transactionSearchRequest.searchFilter.postDateRange.toDate=04-01-2014

Following this didn't help, since it's not updated.

Update: I've corrected the dates, it was a typo here and didn't appear on the actual request.


Solution

  • Dates sent to Yodlee are not ISO standard and can be done as
    MM-dd-yyyy
    or
    MM-dd-yyyyTHH:mm:ss.000Z.
    e.g. :
    "transactionSearchRequest.searchFilter.postDateRange.fromDate":"03-22-2014T00:00:00.000Z", "transactionSearchRequest.searchFilter.postDateRange.toDate":"06-21-2014T23:59:59.000Z",

    HOWEVER outbound dates are ISO standard e.g.
    "postDate" : "2014-06-20T00:00:00-0700",

    The REST API needs a lot of work, this is just one of the many issues we have come across. Don't get me started the on the lacking documentation, the incorrect documentation, ignoring HTTP protocols, mixed serialization approaches, java exceptions over the wire...

    IMO It is not good enough for a paid for service

    :(