On my Pardot form I would like to use zip code to pull up a custom list of stores in that zip code for the prospect to select from. This action would be similar to the google places autofill function but be pulled from my own custom list of stores possibly from a spreadsheet. This spreadsheet is too long to just add all of the stores to a custom drop down field. I understand the Pardot API can pull data out of Pardot into an external system, but how do I pull data in from an external system (The data would come from SQL Server 2014)? #.Pardot Form #.API #.Query #.SQL Databases
1 个回答
You're likely better to use a Pardot Form Handler, and then custom code your own form using a native web language to do what you're looking to do.
At my old employer we used that approach to do things like custom fill cities and streets based on postal code, etc. The form was php and interacted with a location database, and then submitted to Pardot via Form handler.
