select top 1 fi.subscriber, * from tblNewWestern nw, tblFreeAccessUsers1 fi where fi.surveyDownPmt != '0' and fi.surveyDownPmt is not null and fi.nwDecision='yes' and fi.subscriber is null and fi.email_id = nw.email and fi.market_area = 'HHI' and newWesternList = 1 and timeStamp < '9/17/2025 7:52:15 AM' and timeStamp > '2025-07-28 13:24:41.000' and (market_area is not null or len(newWesternArea) > 7 or len(market_area) > 3) and sentLead is null order by timestamp desc;

✓ Lead successfully submitted to New Western

API DEBUG INFO:

API URL: https://api.newwestern.io/v1/leads/submit

API Key: a2JTQ000000f11l2AA-20250902173943

JSON Data Sent:

API Response:

Status: SUCCESS

Sent kane-MO Trent
resp:{"leadId":"87940668-3e9b-4063-b734-1193ce88c8a2"}
qry:update tblNewWestern set sentLead = 'Success' where ID = '160205'