last_name in /meetings/{meetingId}/registrants API method. | Community

Newcomer

Question

last_name in /meetings/{meetingId}/registrants API method.

Forum|Forum|3 years ago
January 17, 2023
2 replies
12 views

Hello. I am running into a sporadic using the /meetings/{meetingId}/registrants API method.

Specifically, we occasionally encounter participant arrays without a last_name key. See examples below.

All of the other keys are always present -- in the same order -- whether or not a value is available for them. last_name, however, is often missing, usually at least a few times per meeting (this client averages something like 100 per meeting). This causes issues for us when iterating through participants to write them into a .CSV file for export to our ESP...

Any ideas? Whether it's required or not (I"ve asked the client to confirm), shouldn't at least the key be present in the data array?

[21] => stdClass Object
(
[id] => -5pynOXRQ3GU******
[first_name] => Steve
[last_name] => Smith
[email] => ss****mail.com
[address] => 
[city] => 
[country] => 
[zip] => 
[state] => AZ
[phone] => 
[industry] => 
[org] => 
[job_title] => 
[purchasing_time_frame] => 
[role_in_purchase_process] => 
[no_of_employees] => 
[comments] => 
[custom_questions] => Array
(
[0] => stdClass Object
(
[title] => What organization/association are you with?
[value] => S*****Insurance
)

)

[status] => approved
[create_time] => 2023-01-10T23:45:31Z
[join_url] => https://us02web.zoom.us/w/81093361645?tk=PWqv1-****hoZz09
)

[22] => stdClass Object
(
[id] => sK9h2oCITHKlmvV****
[first_name] => Heidi A
[email] => heidi****@gmail.com
[address] => 
[city] => 
[country] => 
[zip] => 
[state] => CA
[phone] => 
[industry] => 
[org] => 
[job_title] => 
[purchasing_time_frame] => 
[role_in_purchase_process] => 
[no_of_employees] => 
[comments] => 
[custom_questions] => Array
(
[0] => stdClass Object
(
[title] => What organization/association are you with?
[value] => Ph****ual
)

)

[status] => approved
[create_time] => 2023-01-10T16:04:23Z
[join_url] => https://us02web.zoom.us/w/81093361645?tk=pwpAwUZvWIJlCEyx8IZSuJXJRKIobi8****Zz09
)

[34] => stdClass Object
(
[id] => ou4mE3Y7RJmqvr***
[first_name] => Adam
[last_name] => Smith
[email] => ame****global.net
[address] => 
[city] => 
[country] => 
[zip] => 
[state] => CA
[phone] => 
[industry] => 
[org] => 
[job_title] => 
[purchasing_time_frame] => 
[role_in_purchase_process] => 
[no_of_employees] => 
[comments] => 
[custom_questions] => Array
(
[0] => stdClass Object
(
[title] => What organization/association are you with?
[value] => Amer****its
)

)

[status] => approved
[create_time] => 2023-01-04T18:23:20Z
[join_url] => https://us02web.zoom.us/w/810933616****EhoZz09
)

[35] => stdClass Object
(
[id] => Pnqre-1gST-MxN5****
[first_name] => Frank
[email] => fuo***st.net
[address] => 
[city] => 
[country] => 
[zip] => 
[state] => CA
[phone] => 
[industry] => 
[org] => 
[job_title] => 
[purchasing_time_frame] => 
[role_in_purchase_process] => 
[no_of_employees] => 
[comments] => 
[custom_questions] => Array
(
[0] => stdClass Object
(
[title] => What organization/association are you with?
[value] => ****
)

)

[status] => approved
[create_time] => 2023-01-04T17:57:07Z
[join_url] => https://us02web.zoom.us/w/81093361645?tk=3NrKuks-uc-Gwl1moE-rBcajP0wDwT****oZz09
)

yorn_gregorAuthor

Newcomer

Client has confirmed that 1) the last_name field in their registration setup is marked as required and 2) the last_name value actually exists on Zoom's end, yet we're not receiving it with their record.

yorn_gregorAuthor

Newcomer

An imperfect (but workable) solution to this issue:

When parsing the array, set a variable like $last = "first_name" if the key is 'first_name'. Next time through the loop, check that $last == "first_name" and confirm that the $value contains '@'. If it DOES, it's an email, not a last_name. So, in our case, we insert an empty "", in the CSV. We're still missing the last name, but at least the .CSV isn't offset...