Retrieve a list of leads filtered by date via the API

Andrew K. shared this idea ago

Completed

Is there a way to retrieve a list of leads filtered by an arbitrary date? Ideally I'd want something like this to work—

$ http get 'https://www.inflatableoffice.com/api1/leads/' \
> apiKey=="$IO_API_KEY" \
> limit=='3' \
> status[]=='4921' status[]=='29613' status[]=='6967' status[]=='9013' \
> date=='8/1/2017 - 8/1/2017' \
> | jq '.items[].eventstarttime'
"2023-04-25T12:15:00-07:00"
"2023-04-25T12:15:00-07:00"
"2020-02-22T12:00:00-08:00"

—but of course right now the status[] and date parameters are ignored. Specifying the statuses via a predefined filter would be fine, but I need the date to be variable.

I like this idea

Best Answer

IO S. ● 7 years ago

Try the following:- switch api1 to api2

- &status[]=4921&status[]=29613....

- &date=URLENCODE('2023-04-25 - 2024-04-25')

You should be able to build the URL the same way that the view report URL does for filtering.

Comments (2)

IO S. ● 7 years ago ●

Try the following:- switch api1 to api2

- &status[]=4921&status[]=29613....

- &date=URLENCODE('2023-04-25 - 2024-04-25')

You should be able to build the URL the same way that the view report URL does for filtering.

URL

Andrew K. ● 7 years ago

Thanks, that sounds like just what I need! It looks like it's having trouble generating the response, though:

$ http --verbose get "https://www.inflatableoffice.com/api2/leads/?apiKey=${IO_API_KEY}&status[]=9013&date=8%2F1%2F2017%20-%208%2F1%2F2017";
GET /api2/leads/?apiKey=redacted&status[]=9013&date=8%2F1%2F2017%20-%208%2F1%2F2017 HTTP/1.1
Accept: */*
Accept-Encoding: gzip, deflate
Connection: keep-alive
Host: http://www.inflatableoffice.com
User-Agent: HTTPie/0.9.8
HTTP/1.1 200 OK
Access-Control-Allow-Methods: *
Access-Control-Allow-Orgin: *
Connection: Keep-Alive
Content-Encoding: gzip
Content-Length: 376
Content-Type: application/json
Date: Thu, 28 Sep 2017 20:39:30 GMT
Keep-Alive: timeout=5, max=100
Server: Apache/2.4.25 (Red Hat) OpenSSL/1.0.1e-fips
Vary: Accept-Encoding,User-Agent
X-Powered-By: PHP/7.0.23
Fatal error: Uncaught Error: Call to undefined method stdClass::balance_due() in /var/www/vhosts/inflatableoffice.com/httpdocs/api2/API.class.php:3257
Stack trace:
#0 /var/www/vhosts/inflatableoffice.com/httpdocs/api2/API.class.php(1744): MyAPI->cleanClass(Object(stdClass), 'lead', '-800', '1', false)
#1 /var/www/vhosts/inflatableoffice.com/httpdocs/api2/API.class.php(1165): MyAPI->leads_list()
#2 /var/www/vhosts/inflatableoffice.com/httpdocs/api2/API.class.php(81): MyAPI->leads(Array)
#3 /var/www/vhosts/inflatableoffice.com/httpdocs/api2/api.php(15): API->processAPI()
#4 {main}
thrown in /var/www/vhosts/inflatableoffice.com/httpdocs/api2/API.class.php on line 3257
Sorry, an error has occurred. Please try again later. The developers have been notified.

I've also tried adding columns[]=1 to skip the balance due calculation but it doesn't seem to change anything.

URL

IO S. ● 7 years ago

This issue should now be fixed.

URL