Webhook for USPS Lookup

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
How can I use a Webhook to perform a postal address lookup against
data entered by a user on a record add or modify, and save the data returned?
 (Not that it matters, but the app predates the Address field type, so
there are five individual fields holding the address.)


Only way I can think of doing this is to write my own server-side script called from the Webhook, but wondering if anyone can think of a pure QuickBase technique instead.

Note that I know how to get the postal address using a USPS URL, and have added a dynamic lookup upon opening a form on the record.  But I want to trap all changes (including imports and grid edits) to the address fields, do the USPS lookup, save the USPS values, and set a QuickBase checkbox indicating there is a discrepancy between the address entered and the USPS result so I can create a report to see those records, which is the ultimate goal.

Photo of Joe Acunzo

Joe Acunzo, Champion

  • 270 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Use redline13.com Zip Code API - free up to reasonable limit.

https://www.redline13.com/blog/tag/zi...

It supports CORS so you can call client side using JavaScript.
Photo of Joe Acunzo

Joe Acunzo, Champion

  • 240 Points 100 badge 2x thumb
Thanks Dan, but I cannot use a client-side solution as I want to trap record adds and modifies made by imports and grid edit.  Any other thoughts?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Well the events for imports and grid edit eminate from client side events so there has to be a way to trap them. I am at a meetup so I can't type much so let me think about it.