Richard Schnitzler (rschnitzler@shield-legal.com)
2025-05-30 13:56:42

Ops, Data, and what was the other Epic?

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-05-30 13:59:00

Integration! NM, thank you!

Dustin Surwill (dsurwill@shield-legal.com)
2025-06-03 13:19:05

{\"message\":\"Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Error when updating or inserting synced contact. Internal error: \\r\\n1: Length of Contact First Name is too long, please rectify it. (QB Maximum Limit is 25 Chars): []\",\"logId\":\"a0EVT00000D9jfy2AB\",\"isSuccess\":false,\"intakeId\":null,\"accountId\":null}

Dustin Surwill (dsurwill@shield-legal.com)
2025-06-09 14:12:15

$oldPath = (Get-ItemProperty -Path 'Registry::HKEY_CURRENT_USER\Environment' -Name PATH).Path $newPath = $oldPath + ';C:\NewFolderToAddToTheList' Set-ItemProperty -Path 'Registry::HKEY_CURRENT_USER\Environment' -Name PATH -Value $ newPath

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-01 16:41:00

https://developer.mozilla.org/en-US/docs/Web/HTTP/Reference/Status

MDN Web Docs
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-03 12:36:41

Found the questionnaire info, let me know if you need anything else

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-03 12:39:16

Have @Daniel Schussler give you a list of the previous integrations so you can pull the questionids. Then if you need more work have him show you how to update the mapping files to the new format

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-03 12:39:35

Whoops, sorry meant that for Daniel

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-03 12:39:58

Slack doesn't always switch chats when I click once

๐Ÿ‘ Dustin Surwill
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-11 16:46:35

<Response [200]> {"timestamp":"2025-07-11 21:38:26","message":"Records processed successfully","matterId":"a0LVT000009Ip3h2AC","isSuccess":true,"accountId":"001VT00000UJ2RRYA1"}

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-11 17:08:16
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-15 12:10:07

most of the DL FA: sl_co_council_arrangement_id_c = { 599: "a4CVT000000eFwP2AU", 603: "a4CVT000000cLUr2AM", 638: "a4CVT000000aDYD2A2", 640: "a4CVT000000a5Nl2AI", 1643: "a4CVT000000kfg52AA", 1674: "a4CVT000000eGnd2AE", 1676: "a4CVT000000eoir2AA", 1791: "a4CVT000000ewLR2AY", 1799: "a4CVT000000aDpx2AE", 1806: "a4CVT000000ewRt2AI", 1807: "a4CVT000000ewbZ2AQ", 1839: "a4CVT000000h5aj2AA", 1860: "a4CVT000000kg4H2AQ", 1879: "a4CVT000000cLBV2A2", 1908: "a4CVT000000tXkv2AE", 1915: "a4CVT000000eovl2AA", 1923: "a4CVT000000h5Z72AI", 1941: "a4CVT000000kfrN2AQ", 1949: "a4CVT000000gxJp2AI", 1955: "a4CVT000000tjan2AA", 1975: "a4CVT000000qS6f2AE", 1976: "a4CVT000000qjfN2AQ", 1977: "a4CVT000000knLt2AI", 1987: "a4CVT000000mUQP2A2", 1995: "a4CVT000000kfrN2AQ", 1998: "a4CVT000000kenF2AQ", 2000: "a4CVT000000rbHZ2AY", 2001: "a4CVT000000rozZ2AQ", 2015: "a4CVT000000q9jx2AA", 2016: "a4CVT000000rDOv2AM", 2040: "a4CVT000000vQU12AM", 2042: "a4CVT000000v4Ez2AI", 2044: "a4CVT000000uSpd2AE", 2064: "a4CVT000000q9jx2AA", 2074: "a4CVD0000003wx72AA", }

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-18 11:08:00

Please review. Check for 0 instances of c- and that the account and signer are filled out

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-18 11:13:55
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-18 11:32:46
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-18 11:37:29
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-18 12:41:52

Please check the folder to make sure only DL data is in this folder: https://drive.google.com/drive/folders/11j2pg8n3SECVOk9_AUPSzHX0V0jZnO6h

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-18 21:40:16

Can I get the list of campaigns that we marked in red this afternoon?

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-19 12:03:22

Sure, I'll run into the office and send it to you in a bit

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-19 15:15:58

https://www.howtogeek.com/what-is-bazzite-linux/

How-To Geek
๐Ÿ‘ Richard Schnitzler
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-19 15:42:50

Here is the edited copy

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-21 16:18:15

My notes from the meeting this afternoon, you will probably have questions: backfill first 10 from friday - skip ones triggered in new endpoint if we feel comfortable with the tests from the weekend then backfill identify if we are missing more question maps missing data first, then skip docs based on list re-trigger leads missing docs that they ask about

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-21 16:18:41

3 is already done

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-21 16:35:41
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-21 16:35:44
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:10:22

What's your experience with JSON & Python? Have you looked at the integration repo (https://github.com/shield-legal/gcp-integrations)? Have you looked at the current PR we working in for DL (https://github.com/shield-legal/gcp-integrations/pull/235)?

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 13:14:43

Had to deal with JSON enough, Python is not my wheelhouse, but I have done it a few times before. I have looked at the repo, but not the PR

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 13:14:52

Had to deal with JSON enough, Python is not my wheelhouse, but I have done it a few times before. I have looked at the repo, but not the PR

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:16:40

Look through the main.py s of the ones we have completed and new_endpoint.py. if you are comfortable, we should have you work on some. At least we should get you helping with the mappings

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:18:46
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 13:20:20

Yes, and yes, mapping seems straightforward, the c-#### to field values based on the docs I put together under each Campaign number

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 13:21:02

Main for campaign level fields, like parent matter or record type values

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:23:15

@Daniel Schussler will show you the steps on the next one he does. I will review you payload.json s

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 13:24:06

I was reviewing with him prior, I can take a crack at it, got a number?

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:24:28

2046

๐Ÿ‘ Richard Schnitzler
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:26:45

I like to use LR for the mapping (the link above is for 518) since the question order is not guaranteed via the csv/excel or LR api.

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:39:36

Set-ExecutionPolicy -ExecutionPolicy Unrestricted -Scope CurrentUser

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:41:38
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:45:37

gcloud init gcloud auth application-default login

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 13:49:41
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 14:43:49

providers require a roledescription

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 14:58:11

Don't leave empty c- in the mapping

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 18:39:38

the lr_questions.json was modified in your commit, please revert the changes on L86 & L90

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 18:40:44

Try to use rebase instead of merge next time

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 18:41:11

I just pulled ๐Ÿ˜ฆ

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 18:41:17

Weird, alright

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 18:42:03

vs code defaults to merge, not sure if you can fix without pulling via cli. pycharm asks everytime. rebase makes for a cleaner history

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 18:52:19

okay, wait, in my file?

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 18:52:26

Had to setup git on the laptop

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 18:52:52

Had to setup git on the laptop

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 19:10:28

OH

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 19:20:13

Are you available to chat ?

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 19:20:31

not currently, awaiting call from Joe about backfill

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-22 19:20:35

not currently, awaiting call from Joe about backfill

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 19:23:05

Fair enough, just want to double check

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 19:29:23

wait, nm, i see it, fixed, found the setting in git and changed it

๐Ÿ‘ Dustin Surwill
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-22 19:29:36

CARRY ON, my bad

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-23 15:19:47

We will need to back up all the docs / sops

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-23 15:20:28

Exported most as Pdfs

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-23 15:20:32

But yes

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-24 13:54:40

https://plugins.jetbrains.com/plugin/22952-oracle-oci-toolkit

JetBrains Marketplace
Tags:
Database, Cloud
Dustin Surwill (dsurwill@shield-legal.com)
2025-07-24 13:55:04

https://plugins.jetbrains.com/plugin/10253-illuminated-cloud-2

JetBrains Marketplace
Tags:
Externally-Paid, Programming Language
Rating:
โญโญโญโญโญ
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-28 16:47:11

Looks good! Read them and didn't see any issues!

Dustin Surwill (dsurwill@shield-legal.com)
2025-07-29 10:47:31

TortShield1

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-07-31 15:29:33
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-06 20:10:11

For AWKO prioritize 2139 (was not on our Monday until now). This is campaign they were talking about in the email. The other 3 are live but they have not asked for integration on them, I will get confirmation that we need to do them.

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-06 20:52:25

Good to know, thanks

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-07 01:39:26

https://www.salesforceben.com/why-is-salesforce-flow-making-its-way-out-of-the-setup-menu/

Salesforce Ben
Written by
Tim Combridge
Estimated reading time
6 minutes
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-07 10:17:50

Translation: Smokescreen for finally deleting Workflows

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-07 17:18:26

https://console.cloud.google.com/storage/browser/shield-legal-2084/654134/intake

accounts.google.com
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-07 17:52:43

AWKO Key: lghq6c3cg9be

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-08 00:31:06

https://youtu.be/N5xhOqlvRh4?si=g2I5Qgg7X3TE6T

YouTube
Jeff Geerling (https://www.youtube.com/@JeffGeerling)
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-08 11:24:47

https://peps.python.org/pep-0008/

Python Enhancement Proposals (PEPs)
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-08 17:38:33

=CONCATENATE("""Q:", F2, ":",B2,""": """, F2, """,")

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-08 17:56:23

if 'test' in data: postgres.update_response(obj.log_row['id'], f'&lt;Response [000]&gt; {json_data}') return goes in the handle_awko function before the intake_response = <a href="http://request.post">request.post</a>(...)

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-08 18:06:58

2073 missing test in mapping and you somehow removed my changes...

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-11 13:11:21

https://console.cloud.google.com/storage/browser/shield-legal-2139/506852/intake https://console.cloud.google.com/storage/browser/shield-legal-2073/506852/intake

accounts.google.com
accounts.google.com
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-11 13:20:30

https://console.cloud.google.com/bigquery?inv=1&invt=Ab5NqQ&project=tort-intake-professionals&ws=!1m5!1m4!4m3!1stort-intake-professionals!2sIntegrations!3snewintegrationslog|https://console.cloud.google.com/bigquery?inv=1&invt=Ab5NqQ&project=tort-intake-professio[โ€ฆ]take-professionals!2sIntegrations!3snewintegrationslog

accounts.google.com
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-14 14:42:20
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-15 19:18:57

Please give feedback on the Salesforce API docs for Milberg: https://tortintakeprofessionals.monday.com/boards/4677317281/pulses/9831775084

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-15 19:25:29

Feedback is as follows: Really nice ๐Ÿ‘

๐Ÿ‘ Dustin Surwill
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-15 19:28:14

Seriously though, they even remembered the Salesforce payload limit. Makes sense because they're expecting the files in the call, so other than that this mapping seems fairly straightforward

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-15 19:29:35

The biggest deviation from those stuff I've seen already is the Auth 2.0, But that's hardly complex logic

โœ… Dustin Surwill
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-17 18:23:14

https://www.youtube.com/watch?v=VZZ2XicjRk0

YouTube
TechFi (https://www.youtube.com/@TechFi-te3ik)
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 11:13:38

where are we on AWKO?

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-18 11:15:10

If I am not mistaken, we were waiting on commiting to main based on the feedback they would give us?

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 11:16:02

Did we do another round of payload QA after applying the feedback?

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-18 11:16:36

We did not, just the first internal QA

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 11:16:54

Lets do that

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-18 11:17:39

So run the lead thro again and submit them in Integrations QA channel ?

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 11:17:57

yes, make sure test in the mapping

๐Ÿ‘ Richard Schnitzler
Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-18 11:18:34

Wait, re-add test?

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 11:18:53

yes, so that it generates a payload and not send to the firm

โœ… Richard Schnitzler
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-18 15:42:36
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-20 14:18:48

the urls should include test such as in the following: https://referraltest.awkolaw.com/case https://referraltest.awkolaw.com/document

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-20 14:18:51

my mistake

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-20 18:46:44

The latest change you made for AWKO we want to revert since we want to fail fast (fail instead of try to continue), when missing the external_id

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-20 18:47:44

Ah, fair, yeah I got the error for case ID and I was trying to fix

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-20 18:48:00

Ah, fair, yeah I got the error for case ID and I was trying to fix

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-22 12:49:49
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 12:52:09

To look at on your own time: https://www.facebook.com/groups/it.humor.and.memes/

facebook.com
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-22 17:14:39

For next time only send the general case questions tab

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-25 12:24:13

For Milberg lets mention the full questionnaire will be uploaded (include example) and what if any extra format they would like such as CSV or JSON. Lets also give the list of 22 questions that we are using in the API.

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-25 12:24:22

For Milberg lets mention the full questionnaire will be uploaded (include example) and what if any extra format they would like such as CSV or JSON. Lets also give the list of 22 questions that we are using in the API.

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-25 12:41:28
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-26 12:20:38
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-26 15:59:22

CR#1

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-27 11:03:15

https://youtu.be/uaEzsPt-1KQ?si=eK1nEuDg5ZInnzU4

YouTube
LegalEagle (https://www.youtube.com/@LegalEagle)
Dustin Surwill (dsurwill@shield-legal.com)
2025-08-27 17:00:01

Please fix:

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-27 17:04:01

Change L123 in AWKO main from CASE_ID to CaseID

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-27 17:04:17

The case of the letters are the problem

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-27 17:09:36

CASE_ID Error Solution V1-HASH:e9d00e8912708e394342577fde343b969c1b8c65

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-27 17:13:02

We do not send tests to the prod environments unless asked. In AWKO we were not asked. Both you and him did not check that the documents were uploaded.

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-27 17:26:42

"first production case" not another test

Richard Schnitzler (rschnitzler@shield-legal.com)
2025-08-27 17:28:45

Explain to me the distinction

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-28 15:44:20

Also you are missing some imports: ```import base64 import csv import importlib import inspect import io import logging from os.path import exists

import functions_framework import requests from flask import Request

from cloudpostgres import IntegrationPostgres from gcputils import functionmapping, IntegrationMappingObject # , parseaddresswithunit from scriptTest import parseaddresswith_unit```

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-29 14:00:05

You said we would. We needed to ask if they wanted a backfill. If we do it and they dont want it because their people are fast then we are create duplicates in their system and they will be mad

Dustin Surwill (dsurwill@shield-legal.com)
2025-08-29 16:42:29