James Turner (jturner@shield-legal.com)
2025-07-31 15:28:44

Can y'all read my handwriting?

IMG_20250731_132805.jpg
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-31 15:30:00

is leadwithcall_info in postgres?

James Turner (jturner@shield-legal.com)
2025-07-31 16:00:38

No, it uses PCTID so you'll need to bring it over from BQ, or give Chris access to BQ

James Turner (jturner@shield-legal.com)
2025-07-31 16:00:59
image.png
James Turner (jturner@shield-legal.com)
2025-07-31 16:01:43

Then cut up the name of the recording file to agent_name and timestamp

James Turner (jturner@shield-legal.com)
2025-07-31 16:03:42

and join on these bad boys

image.png
Chris Krecicki (ckrecicki@shield-legal.com)
2025-07-31 16:04:42

'download_filename': f"{agent_name}-{year}-{month}-{day}-{hour}-{minute}-{second} {phone}.mp3"

James Turner (jturner@shield-legal.com)
2025-07-31 16:09:02

You can create a scheduled piece of code that pulls from that table in BQ and writes to Postgresql, If I'm remembering right, I believe we did something similar before?