Malissa (malissa@shield-legal.com)
2024-08-22 15:09:06

totally didn't remember where it was

Malissa (malissa@shield-legal.com)
2024-08-22 15:09:08
image.png
👍:skin_tone_4: Ahsan
Malissa (malissa@shield-legal.com)
2024-08-29 14:50:24

So just contracts in the folder and we should be good. 🙂

Malissa (malissa@shield-legal.com)
2024-09-09 15:11:44
image.png
Malissa (malissa@shield-legal.com)
2024-09-12 13:50:52

"I've heard of Netscape but i've never used it."

Me:

Ahsan (ahsan@shield-legal.com)
2024-09-12 13:57:25

lol same, when aol stoppped giving out the free cds had to used netscape for a bit

Malissa (malissa@shield-legal.com)
2024-09-12 13:58:00

i'd use those CDs for coasters. SOOO many cds

Malissa (malissa@shield-legal.com)
2024-09-12 13:59:32

i think i'm broken for the day

Ahsan (ahsan@shield-legal.com)
2024-09-12 14:02:14

Those 90 day stints for internet were the foretelling of the misery of a subscription model to come, we did not heed the warning

Malissa (malissa@shield-legal.com)
2024-09-12 14:05:34

totally. we all thought it was just like Columbia House. 😞

Malissa (malissa@shield-legal.com)
2024-09-12 14:14:09

OMG. Dustin might not know what Columbia House is! O.o

Ahsan (ahsan@shield-legal.com)
2024-10-04 12:27:34

PROD - CA Juvenile Hall Abuse - Miller - Onder - Shield Legal

Ahsan (ahsan@shield-legal.com)
2024-10-04 12:28:59

is this a smart advocate

Ahsan (ahsan@shield-legal.com)
2024-11-06 12:37:35

So Andon is like this gif then?

Malissa (malissa@shield-legal.com)
2024-11-06 12:38:05

YES!

Malissa (malissa@shield-legal.com)
2024-11-06 12:38:07

that's it

Malissa (malissa@shield-legal.com)
2024-11-06 12:38:59

on assembly lines stations have stop lights (red yellow and green). if a light goes red, everyone is supposed to stop and come fix the issue

Ahsan (ahsan@shield-legal.com)
2024-11-18 10:21:03

Morning Mal, is the file cabinet thing still under my desk?

Malissa (malissa@shield-legal.com)
2024-11-18 10:38:37

i think it was? i can't remember.

Malissa (malissa@shield-legal.com)
2024-11-18 10:38:40

James is going over there

Malissa (malissa@shield-legal.com)
2025-01-09 14:11:22

I didn’t see a message from you that we are good to have Ashley do her thing

Malissa (malissa@shield-legal.com)
2025-01-09 14:11:29

I might have just missed it.

Malissa (malissa@shield-legal.com)
2025-01-09 16:37:21

hey @Ahsan can you type out the answer to Rahul's email for me? I don't remember how to word it lol

Ahsan (ahsan@shield-legal.com)
2025-01-09 16:37:41

already drafting response

Malissa (malissa@shield-legal.com)
2025-01-09 16:38:33

:60fpsparrot:

Malissa (malissa@shield-legal.com)
2025-01-09 16:44:52

i'm also taking his non-answer as a "yeah we did update"

Ahsan (ahsan@shield-legal.com)
2025-02-06 12:24:12

Hey Mal, would you like to send a stern email/request to rahul about our vga levinson payloads not catching a return response?

Ahsan (ahsan@shield-legal.com)
2025-02-06 12:31:14

Here is the draft:

Hello Rahul,

Circling back to the case creation for leads being sent. We are getting the 200 call for leads again with no return id. I have included the payload for one of the examples we are seeing. Can you look into why the system is not generating the case when the lead is being pushed into Smart Advocate? Thank you for your attention to this matter.

Best Regards; Ahsan Tebha Data Engineer.

payload.json
Ahsan (ahsan@shield-legal.com)
2025-03-03 15:47:32

SELECT ** FROM `integrations-tip.gcp_integrations_postgres.lead_data_view` WHERE case_type_id in (1705, 1749, 1892, 1794) -- enter case type here AND external_id is null AND DATE(intake_processed_at) = CURRENT_DATE - interval 1 day ORDER BY intake_processed_at DESC LIMIT 1000;

Ahsan (ahsan@shield-legal.com)
2025-03-03 15:47:38

https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m21!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s10f137cb-3789-4103-b473-0132faa5edbe!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s767719bd-bab7-42c6-88ce-d7480e7ad777!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s93c6c39a-ad81-423a-972f-0c69b4a0f10b!2e1|https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m21!1m6!12m[…]ip!2sus-west4!3s93c6c39a-ad81-423a-972f-0c69b4a0f10b!2e1

accounts.google.com
Google Cloud Platform
Google Cloud Platform lets you build, deploy, and scale applications, websites, and services on the same infrastructure as Google.
Original URL: https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m21!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s10f137cb-3789-4103-b473-0132faa5edbe!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s767719bd-bab7-42c6-88ce-d7480e7ad777!2e1!1m6!12m5!1m3!1sintegrations-tip!2sus-west4!3s93c6c39a-ad81-423a-972f-0c69b4a0f10b!2e1
Ahsan (ahsan@shield-legal.com)
2025-04-30 17:59:31
bailey glasser.png
😂 Malissa
Ahsan (ahsan@shield-legal.com)
2025-05-12 13:26:37

Hey Dustin said he made a crump channel already. Did he invite to it?