Search for invalid entries

This of course can be done with script and is a good candidate for using the Async / Await technique because of the large number of API calls you would have to make.

This is how I would proceed:

1. Iterate over all applications
2. iterate over all tables in application
3. iterate over all fields in table
4. perform a query for all records of the current table including the current field using API_DoQuery with &fmt=structured. In addition to the record data the response will include information about the field and the current choices allowed if the field is a multiple choice field
5. Now iterate over every record in the response looking for field choices that are not in the schema choices for the field
6. report illegal choices as they are encountered and continue the iterations

This may sound complicated but it will turn out to be pretty simple. I will probably put this example on my to do list and knock it off when I have more time. 

Below are a few screenshots of a preliminary approach to the problem. The first screenshot shows a report with both allowable choices for two fields and a few illegal choices. The second screenshot shows a portion of the XML response listing the allowed choices for one of field. The third screenshot shows the XML response. 

Report of All Records with allowable and illegal choices:

Fragment of XML Response showing allowable choices for one field:



Fragment of XML Response showing all data records: