Linking zip codes to underlying data for display in survey

Upload the zip code data into a web based database table (e.g., MySQL). Write a web service script to query the zip code table and output the data in json format. Call the web service from the survey flow. It will return the zip code data in embedded data variables. Pipe the embedded data variables into your survey questions.

Thank you!! Do you have suggestions for the best web based database table to use? I'm having trouble finding resources for how to set that up.

If you are using a commercial zip code product, some of them include an API that you could call as a web service. If so, you could avoid setting up your own database and writing your own script.
The answer to your question depends on your web server. If you have a web hosting account, most include MySQL.

Thanks so much! I don't have a web hosting account already but I'm looking into trying to get one up and running with the zipcode csv spreadsheet. Is it possible to do this internally in Qualtrics instead, for example with a javascript object?

Thanks so much! I don't have a web hosting account already but I'm looking into trying to get one up and running with the zipcode csv spreadsheet. Is it possible to do this internally in Qualtrics instead, for example with a javascript object?

Thank you!! That's really helpful!
I think I have everything set up correctly, but I'm having trouble with the PHP code to get the rows of the table to qualtrics. I know it's connecting correctly to the web address because if I enter the password wrong, I get the error message that I entered into script, but if I enter my password correctly then I don't see anything on qualtrics. Do you have advice on how to fix this? Thanks again!

(Sorry about the image of the code, for some reason I couldn't post my comment with the text of the code there!)

There may be other issues, but you have an error in your query. Instead of:
SELECT * FROM `TABLE 2'
It should be:
SELECT * FROM `TABLE 2`
Run your script from a web browser to debug it first before trying to do it from Qualtrics.

Also, if still not works, then you may have to add below line as first line of script, to call API from different domain

header('Access-Control-Allow-Origin: *');