GuidesAPI ReferenceSupport

Read AR Activities

get https://secure.fusebill.com/v1/aractivities?query=startDate:;endDate:&pageSize=100&pageNumber=0

This action will allow you to retrieve a complete list of account receivable accounting transactions across your Fusebill environment, within a specified date range.

This call supports date filtering (Read More)
&query=parameterName:Value

Parameter NameAcceptable ValuesParameter NameAcceptable Values
endDateDateTimestartDateDateTime

This call supports pagination (Read More)
&pageSize=100&pageNumber=0
This call supports sorting (Read More)
&sortOrder=Ascending or &sortOrder=Descending
&sortExpression=expression

Examples
curl -X GET "https://secure.fusebill.com/v1/aractivities?query=startDate:2017-01-10T00:00:00;endDate:2017-01-10T00:00:00.000Z&pageSize=100&pageNumber=0" \
	-H "Content-Type: application/json" \
	-H "Authorization: Basic {APIKey}"

//query parameter
string startDate = "2017-01-01T00:00:00";
string endDate = "2017-01-30T00:00:00.000Z";
//Setup API key
string apiKey = "{APIKey}";
//Configure URI
WebRequest request = WebRequest.Create("HTTPS://secure.fusebill.com/v1/aractivities/?query=startDate:"+ startDate + ";endDate:"+ endDate);
//Add Content type
request.ContentType = "application/json";
//Add Api key authorization
request.Headers.Add(HttpRequestHeader.Authorization, "Basic " + apiKey);
//Set request method
request.Method = "GET";
//Perform the request
var httpResponse = (HttpWebResponse)request.GetResponse();
//Record the response from our request
var result = "";
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
  result = streamReader.ReadToEnd();
}

#Import library Requests
import requests
#Pass in a dictionary to the Headers parameter
headers = {'Authorization' : 'Basic {APIKey}', 'Content-Type' : 'application/json'}
#Pass in your URI and Headers
r = requests.get('https://secure.fusebill.com/v1/aractivities?query=startDate:2017-01-10T00:00:00;endDate:2017-01-10T00:00:00.000Z&pageSize=100&pageNumber=0', headers=headers)
print(r.content)
Response
{
        "fusebillId": 655080,
        "customerId": null,
        "effectiveTimestamp": "2019-11-25T21:58:38",
        "transactionType": "Payment",
        "name": "Cash",
        "description": null,
        "productCode": null,
        "paymentActivityId": 1059784,
        "reference": null,
        "manualReference": null,
        "quantity": 1.000000,
        "unitPrice": 97.000000,
        "arDebit": 0.0000,
        "arCredit": 97.0000,
        "glCode": null,
        "invoiceAllocations": [
            {
                "invoiceId": 565624,
                "invoiceNumber": 377,
                "amount": 97.00,
                "outstandingBalance": 0.0000,
                "invoiceTotal": 97.0000,
                "netsuiteId": null,
                "quickbooksId": null,
                "uri": "https://stg-secure.fusebill.com/v1/aractivities/565624"
            }
        ],
        "associatedId": 66799820,
        "id": 66799820,
        "uri": "https://stg-secure.fusebill.com/v1/aractivities/66799820-719"
 }

{
    "ErrorId": 0,
    "HttpStatusCode": 400,
    "Errors": [
        {
            "Key": "Api Error",
            "Value": "201f9-01-01 is not a valid date."
        }
    ]
}
Language
Authorization