|
FASeminars
|
February 20, 2019 at 7:40 am
Hello,
We currently have our Event Expresso registration data being passed to a third-party Marketing Automation system via API connection. The system can see the system fields for event data/details and registrant information however if we add custom QUESTIONS (eg. COUNTRY or PROVINCE) which we did via drop-down menus to control submitted data accuracy, the array cannot see these fields so we can pass the data. Is this a limitation or Event Expresso? Or how can we see these fields also to pass them?
Below is a sample of the array that we can see:
Array ( [registration_id] => 266-5c6c3ec090cdf [is_primary] => 1 [attendee_session] => 2a9936d6636a64c4856fe6f453c04dce-5c6c3ec070b987.37058201 [lname] => Comandix [fname] => WSI [address] => test [address2] => test [city] => test [state] => [country_id] => [zip] => 234234 [email] => projects@comandix.camailto:projects@comandix.ca [phone] => 234234 [date] => 2019-02-19 12:37:04 [payment] => [txn_type] => [coupon_code] => [event_time] => 08:30 [end_time] => 17:30 [start_date] => 2019-03-23 [end_date] => 2019-03-24 [price_option] => General Admission [organization_name] => [payment_status] => Incomplete [payment_date] => [event_id] => 266 [quantity] => 1 [amount_pd] => 0.00 [orig_price] => 899.00 [final_price] => 899.00 [attendee_id] => 21232 [event_meta] => Array ( [venue_id] => 16 [additional_attendee_reg_info] => 1 [add_attendee_question_groups] => Array ( [1] => 1 [2] => 2 [4] => 4 ) [date_submitted] => 2018-08-16 11:28:53 [default_payment_status] => [event_hashtag] => [event_format] => [event_livestreamed] => [] => ) )
Thanks for any help,
Mike
|
|
Josh
|
February 20, 2019 at 10:50 am
Hi Mike,
May I ask where are you getting the array from? In any case, the custom registration form values are stored in the _events_answer table. Since you have the attendee_id from that array, you should be able to use that as a key to identify which answer values to get from the table.
|
|
FASeminars
|
February 21, 2019 at 8:30 am
Hi Josh,
Thanks for replying. Appreciate it.
We get the array from action_hook_expresso_save_attendee_data. How do we get data from user generated questions?
Thanks,
Mike
|
|
Tony
|
February 21, 2019 at 9:16 am
You’ll need to pull them from the database yourself as that hook doesn’t include them (none do iirc).
Take a look at the event_espresso_custom_questions_output() function in \event-espresso\includes\admin-files\misc_functions.php
That will show you how you can pull all questions/answers including system questions (or not if preferred).
Note that function is not what you can use directly, but it will point you in the right direction of how to pull the data.
|
