Support

Home Forums Event Espresso Premium REST API – Deleted Registrations

REST API – Deleted Registrations

Posted: June 13, 2018 at 1:01 pm


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

  • Support Staff

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

  • Support Staff

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

  • Support Staff

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 !

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: publish

Updated by  dassaultfalcon 5 days, 9 hours ago ago

Topic Tags

Notifications

This topic is: resolved
Do NOT follow this link or you will be banned from the site!