CiviCRM 4.7.29, Wordpress 4.9.5
I am unable to do a replace in the API explorer. I can do a "get" however. The situation is that a parent registered for an event, but forgot to change the number of registrants under his registration from 1 (him) to 3 (him + 2 kids). They were under 12 yrs so I just manually entered them. However, the kids now show as Registered_by_ID = null, and I want them to be the ID of the parent.
(NOTE: Am not a developer, just a volunteer with middle level of experience.)
When I do a "get", I can find his 2 kids by participant ID. Next, in API Explorer I use Entity = Participant, Action = Replace, and I would expect that the interface would allow me to choose the Participant I want to perform the action on, followed by a field on which I want to change from one value to another. Instead, it allows me to choose 1 field and 1 value and says it is going to update the database, so I chose no. How do I know what participants this is going to change since it doesn't let me choose who? How does it know what value from -> to I want to change?
I checked the examples here but Registered_by_ID is not listed. Does that mean a replace won't work on that ?
In the end, I'm open to suggestions of either how to get the API explorer to do what I want (change the Registered_by_ID from null to the parent's ID), or else if there's some other obscure way (ie Profiles?).
Thank you.