Zekarias Haile (zhaile@shield-legal.com)
2024-09-25 17:41:20
image.png
Daniel Schussler (dschussler@shield-legal.com)
2024-10-01 14:12:41
Mapping Template - Sheet1.csv
Daniel Schussler (dschussler@shield-legal.com)
2024-10-10 12:33:20
main.py
Zekarias Haile (zhaile@shield-legal.com)
2024-10-10 15:55:55

Chowchilla - Van - Long Form Interview - VAN - Shield Legal- is not exported- you mistakenly mark as yes...

Daniel Schussler (dschussler@shield-legal.com)
2024-10-16 18:01:29

intakeresponse = sendinfo(url,postgres,intake,attachments,data)

Daniel Schussler (dschussler@shield-legal.com)
2024-10-18 17:40:34

"072.124.008 - Your DOB?": @{outputs('EmailRows')[19]}, "072.124.012 - How long did you attend?": @{outputs('EmailRows')[25]}, "072.124.009 - What is the name of the abuser?": @{outputs('Email_Rows')[26]}

Daniel Schussler (dschussler@shield-legal.com)
2024-10-18 17:41:02

ca juv hall abuse miller goldwater

Daniel Schussler (dschussler@shield-legal.com)
2024-10-18 17:41:17

intake 1750

Zekarias Haile (zhaile@shield-legal.com)
2024-10-31 16:44:43

https://console.cloud.google.com/bigquery?project=integrations-tip&ws=!1m11!1m10!12m5!1m3!1sintegrations-tip!2sus-west4!3se528829e-b5e1-40f9-b4c6-7ec52fc73751!2e1!14m3!1sintegrations-tip!2sbquxjob57e7dcdb192e47f73f0!3sus-west4|https://console.cloud.google.com/bigquery?project=integrations-tip&ws=!1m11!1m10!12m5!1m3[…]tegrations-tip!2sbquxjob57e7dcdb192e47f73f0!3sus-west4

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?project=integrations-tip&ws=!1m11!1m10!12m5!1m3!1sintegrations-tip!2sus-west4!3se528829e-b5e1-40f9-b4c6-7ec52fc73751!2e1!14m3!1sintegrations-tip!2sbquxjob_57e7dcdb_192e47f73f0!3sus-west4
Zekarias Haile (zhaile@shield-legal.com)
2024-11-11 12:42:47

1887's test lead ID 626027

Daniel Schussler (dschussler@shield-legal.com)
2024-11-11 12:49:18

thanks I was just about to ask about that haha.

👍 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 10:59:19

Good morning

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 10:59:39

hey man whats up

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 10:59:44

How is it going? Are u by yourself in office?

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 10:59:52

currently

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:00:11

Are you not making it until later?

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:00:29

Oh okay. Will be there once I done with my meeting

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:00:46

sheesh at this rate...

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:00:52

Haha

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:01:00

nah I assume Ahsan will be here in the next 30

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:01:04

and we may even get Nick today

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:01:27

If not... I guess I'll be napping in here

😃 Zekarias Haile
Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:01:33

Ok that will be good to have Nick joining us

👍:skin_tone_3: Daniel Schussler
Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:01:47

yeah been a minute

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:01:56

Enjoy! Turn the lights off

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:02:48

they went off the moment i got in haha

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:05:00

They knew that you gonna take a nap haha

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 11:05:16

and Ahsan and nick just walked in h aha

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:06:23

Haha im sorry that you got distracted

Zekarias Haile (zhaile@shield-legal.com)
2025-01-06 11:06:27

Haha

Daniel Schussler (dschussler@shield-legal.com)
2025-01-06 15:28:06

How to grab payload from mapping and LR

Fill in your case id Go to the storageurl in a separate window Download the intake.json Go to the parent shield legal folder for the case type, and download the testintakemapping.json Go to GCP integration project in vs code Added the two files downloaded into vs code Open up a terminal: python tools/payload.py (contact id)intakeintake.json .\test-intakemapping.json Run it It will create a file

Daniel Schussler (dschussler@shield-legal.com)
2025-01-31 10:30:12

test

Daniel Schussler (dschussler@shield-legal.com)
2025-01-31 16:23:24
image.png
Daniel Schussler (dschussler@shield-legal.com)
2025-02-03 14:05:02

Can you open the door I need to grab something

Daniel Schussler (dschussler@shield-legal.com)
2025-03-12 10:30:51

Can you open the door buddy

Daniel Schussler (dschussler@shield-legal.com)
2025-03-21 13:09:58

caseType: Bard PowerPort Catheter

Zekarias Haile (zhaile@shield-legal.com)
2025-04-03 13:29:43

She said “you’re welcome” btw if you haven’t heard her lol

😂 Daniel Schussler
Daniel Schussler (dschussler@shield-legal.com)
2025-06-13 13:38:54

https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m16!1m4!16m3!1m1!1sintegrations-tip!3e12!1m10!12m5!1m3!1sintegrations-tip!2sus-west4!3s767719bd-bab7-42c6-88ce-d7480e7ad777!2e1!14m3!1sintegrations-tip!2sbquxjob3c46828b1976a94c6c4!3sus-west4&invt=Ab0B3Q&inv=1|https://console.cloud.google.com/bigquery?hl=en&project=integrations-tip&ws=!1m16!1m4!16m[…]quxjob3c46828b1976a94c6c4!3sus-west4&invt=Ab0B3Q&inv=1

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=!1m16!1m4!16m3!1m1!1sintegrations-tip!3e12!1m10!12m5!1m3!1sintegrations-tip!2sus-west4!3s767719bd-bab7-42c6-88ce-d7480e7ad777!2e1!14m3!1sintegrations-tip!2sbquxjob_3c46828b_1976a94c6c4!3sus-west4&invt=Ab0B3Q&inv=1
Zekarias Haile (zhaile@shield-legal.com)
2025-06-13 16:47:18

Have a good weekend man!

Zekarias Haile (zhaile@shield-legal.com)
2025-06-20 11:22:39

https://www.shoepalace.com/products/nike-fj4170-002-air-force-1-07-lv8-medium-olive-mens-lifestyle-shoes-olive-grey

Shoe Palace
Air Force 1 '07 LV8 Medium Olive Mens Lifestyle Shoes (Olive/Grey)
Air Force 1 Low For Men and Women, the Nike Air Force 1 is a must have. It is a retro favorite that has appealed to sneakerheads for decades. The Nike Air Force 1 in Black, and the ever popular White colorway, are must own sneakers. You can find a wide selection of Nike Air Force 1 sneakers at Shoe Palace. Specs Origin
Original URL: https://www.shoepalace.com/products/nike-fj4170-002-air-force-1-07-lv8-medium-olive-mens-lifestyle-shoes-olive-grey
Zekarias Haile (zhaile@shield-legal.com)
2025-07-17 14:05:19

734984

Daniel Schussler (dschussler@shield-legal.com)
2025-07-18 15:50:33
dl_map_builder.py
Zekarias Haile (zhaile@shield-legal.com)
2025-07-21 16:23:43

@Daniel Schussler which part from the excel do I need to save it as csv to ran the dlmapbuilder? Sorry I forgot it

Daniel Schussler (dschussler@shield-legal.com)
2025-07-21 16:27:05

all of it

Daniel Schussler (dschussler@shield-legal.com)
2025-07-21 16:27:20

so you want to make sure you grab the headers

Daniel Schussler (dschussler@shield-legal.com)
2025-07-21 16:27:28

so for this one

Daniel Schussler (dschussler@shield-legal.com)
2025-07-21 16:28:01

from row 2 to everything

Zekarias Haile (zhaile@shield-legal.com)
2025-07-21 16:40:54

i see, thanks

Daniel Schussler (dschussler@shield-legal.com)
2025-07-21 16:45:56

no prob

Zekarias Haile (zhaile@shield-legal.com)
2025-08-25 11:53:01

443638