|
dassaultfalcon
|
June 13, 2018 at 1:01 pm
Hello !
I am trying to get a list of all the registrations that are not deleted, and this is my URL
http://emsdev/wp-json/ee/v4.8.36/events/9/registrations?where%5BREG_deleted%5D=false
But the response comes back with all the registrations (deleted=true and false) Not sure what mistake I am making .. ?
This is one of the registrations in the response –
{:REG_final_price {:raw 0, :pretty “$0.00 <span class=\”currency-code\”>(USD)</span>”}, :REG_group_size 1, :REG_date “2018-06-08T15:56:44”, :REG_count 1, :REG_date_gmt “2018-06-08T19:56:44”, :REG_att_is_going false, :REG_url_link “1-e67cbfd3f1e24abed4d8b098153a3968”, :REG_ID 9, :_calculated_fields {}, :REG_paid {:raw 0, :pretty “$0.00 <span class=\”currency-code\”>(USD)</span>”}, :REG_deleted true, :REG_code “9-2-1-e67c”, :REG_session “da1a8a64a74a3bd6bf5dbdf215a1a32e”}
Thanks,
Amit
|
|
Josh
|
June 13, 2018 at 2:27 pm
Hi Amit,
You may need to url encode the =, like in the following:
?where%5BREG_deleted%5D%3Dfalse
|
|
dassaultfalcon
|
June 14, 2018 at 7:14 am
Hmmm .. Noticed some interesting behaviours .. URL-Encoding it worked. However,
1. http://emsdev/wp-json/ee/v4.8.36/events?where%5BEVT_name%5D=myEvent – for this, if I try to URL-Encode it, it does not work ! I have to send it as noted above.
2. for REG_deleted, when I url-encode it, the ‘deleted=false’ filter works fine. But I tried deleted=true, and that does not work. It still returns the deleted=false registrations !
Thanks,
Amit
|
|
Josh
|
June 14, 2018 at 9:31 am
I think what you saw there is related to the difference between a query param where it’s doing a match vs. a binary operator.
See also:
https://github.com/eventespresso/event-espresso-core/blob/master/docs/C–REST-API/ee4-rest-api-GET-filtering-results.md#related-resources-fields-are-also-queryable
|
|
dassaultfalcon
|
June 15, 2018 at 7:59 am
Thats great ! Thanks for showing me that. Saved me quite a bit of code ..
Actually let me share here what we are trying to do, and may be you can suggest a better way if there is one ..
Our events are on the airport, and there is no internet. But we still want to use the mobile app to scan tickets. To achieve this, we want to install wordpress+eventespresso on a laptop, take that, and a router at the location, create our on LAN/WAN(private), connect some mobile devices to that WAN, and scan tickets.
And in order to achieve that, we will have to copy all the registrations for that event from our server, to the laptop. For that, I am trying to use the API to achieve that.
Are there any suggestions to may be do this smarter or streamline this ?
Thanks,
Amit
|
|
Josh
|
June 15, 2018 at 8:10 am
Hi Amit,
Yes a more streamlined way to move the data over to the laptop would be to use a plugin like WP Migrate DB or WP Migrate DB Pro. This way you can push the data over to the local hosted site on your laptop without having to resort to the complications of using the REST API for something it wasn’t designed to do.
|
|
dassaultfalcon
|
June 18, 2018 at 2:33 pm
Thanks Josh. The WP Migrate DB Pro seems to be working great !
|
