James Turner (jturner@shield-legal.com)
2024-09-25 15:22:11
 
◦ Get Email Attachment:After the trigger, add an action to retrieve the email attachment. Use the “Get attachments” action.
◦ Since there can be multiple attachments in an email, Power Automate will automatically create an “Apply to Each” loop. Don’t worry; it’s just like checking items off a grocery list!
◦ Extract Attachment Content:Inside the loop, you’ll want to extract the content of each attachment.
◦ Use the “Compose” action to isolate the attachment body. Drop the dynamic value from the previous step into the Compose action.
◦ This will return JSON with a field called `contentBytes`, which contains the attachment content.
◦ Convert Content to String:The `contentBytes` field is currently in Base64 format. To work with it, we need to convert it to a string.
◦ Add another Compose action and use an expression to convert the Base64 content to a string. You can use the `base64ToString()` function for this.
James Turner (jturner@shield-legal.com)
2024-10-02 14:47:37
cartographer.zip
Ahsan (ahsan@shield-legal.com)
2024-10-04 11:45:38

FilteredSum = CALCULATE( SUM(TableName[ColumnName]), TableName[ColumnName] = "A" )

Ahsan (ahsan@shield-legal.com)
2024-10-08 12:05:18

set your slack search bar to look like this to check both mpa channels simultaneously

image.png
Ahsan (ahsan@shield-legal.com)
2024-10-08 14:14:37

Hey for your question in the teams channel you want to call me and I can explain better?

James Turner (jturner@shield-legal.com)
2024-10-08 14:33:35

I appreciate- Is it okay if I call a little later, making a lil breakthrough on the similarity checker and I wanna keep this going

Ahsan (ahsan@shield-legal.com)
2024-10-08 14:36:46

Yea np

James Turner (jturner@shield-legal.com)
2024-10-09 12:07:37

Hey man, sorry for not being on site today- I got some funky health stuff going on but it seems to be getting better

Ahsan (ahsan@shield-legal.com)
2024-10-09 12:26:25

np, dont worry about, pop some nyquil and chill, work will still be here regardless

James Turner (jturner@shield-legal.com)
2024-10-09 12:57:21

Heyo- quick q

  1. happens if we have extra fields in our mapping that the client doesn't have for ACTS? And that is Smart Advocate right?
James Turner (jturner@shield-legal.com)
2024-10-09 12:57:33

if I remember right it just gets thrown into a comment box

Ahsan (ahsan@shield-legal.com)
2024-10-09 13:00:42

Yes if they have that defaulted, the law firm can have that feature off

James Turner (jturner@shield-legal.com)
2024-10-09 13:02:09

Cool- I /think/ I have a good mapping but don't know how to test it with their system yet. I reached out to Ralecia Marks to see if she can get me a copy of the fields they see on Smart Advocate but I believe shes out today

James Turner (jturner@shield-legal.com)
2024-10-09 13:02:19

Do you know anyone else on VSS that might have access?

Ahsan (ahsan@shield-legal.com)
2024-10-09 13:04:29

Everyone on vss is in meetings so they arent at their desks today. If this is acts we should have their mappings, ping dwight for them.

👍 James Turner
James Turner (jturner@shield-legal.com)
2024-10-09 13:40:15

Good idea on the specific thread

James Turner (jturner@shield-legal.com)
2024-10-09 13:40:58

I wasn't thinking of the slack channels as individual forums until you did that and suddenly it clicked

Ahsan (ahsan@shield-legal.com)
2024-10-09 14:09:32

np, you will get used to slack and how to search for things

James Turner (jturner@shield-legal.com)
2024-10-09 15:42:15

Thanks for the clarification- In that google sheets you made, is there a way to ID what is priority?

Ahsan (ahsan@shield-legal.com)
2024-10-09 15:43:13

Think we need to add a column for that but you can just ask in the chat if a flow is active or not

Ahsan (ahsan@shield-legal.com)
2024-10-09 15:48:05

also check the notes column on mpa, the lines I am updating I am stating if the flow is off or not

👍 James Turner
James Turner (jturner@shield-legal.com)
2024-10-09 15:50:55

Here I just threw a priority / Flow state column up..

Ahsan (ahsan@shield-legal.com)
2024-10-09 15:53:18

my bad, make the adjustments and data valadation to your liking. Whatever is easier for you guys

James Turner (jturner@shield-legal.com)
2024-10-09 15:53:59

oop sorry lol - I'm on Monday now, but where are you seeing if the flow is active? Or are we just going off of the general status like "Done" or "In Production"?

Ahsan (ahsan@shield-legal.com)
2024-10-09 15:56:56

https://tortintakeprofessionals.monday.com/boards/4592476097/pulses/4592670421?term=md%20juv%20hall&termColumns=XQAAAAKSAAAAAAAAAABBKoKDUfM6yiS6pmkv14EaTOjY7oQdDdHD24i69m5XgqKThszEkG6gYScGHPFz3DmSiqX-YtdoBoOI2CUG20ZipGqZbX7pVfZH4z7kUTbEzuLskMFH-bEpTsr0VcH8CoMyVBXbku-EbsIJ-pc8ukgh3lTdZ9mhtIDfVJ3AAA|https://tortintakeprofessionals.monday.com/boards/4592476097/pulses/4592670421?term=md%20juv%2[…]r0VcH8CoMyVBXbku-EbsIJ-pc8uk_gh3lTdZ9mhtIDfVJ3AAA

tortintakeprofessionals.monday.com
Welcome to monday.com | a new way of working
<a href="http://monday.com">monday.com</a> Work OS is an open platform where anyone can create the tools they need to run every aspect of their work.
Original URL: https://tortintakeprofessionals.monday.com/boards/4592476097/pulses/4592670421?term=md%20juv%20hall&amp;termColumns=XQAAAAKSAAAAAAAAAABBKoKDUfM6yiS6pmkv14EaTOj_Y7oQdDdHD24i69m5XgqKThszEkG6gYSc_GHPF_z3DmSiqX-YtdoBoOI2CUG20ZipGqZbX7pVfZH_4z7kUTb_EzuLskMFH-bEpTsr0VcH8CoMyVBXbku-EbsIJ-pc8uk_gh3lTdZ9mhtIDf__VJ3AAA
Ahsan (ahsan@shield-legal.com)
2024-10-09 15:57:06

open close tracker from the main workspace

Ahsan (ahsan@shield-legal.com)
2024-10-09 15:57:32
image.png
James Turner (jturner@shield-legal.com)
2024-10-09 15:58:13

Ohh- the open/closed gotcha! I was looking under api integrations

James Turner (jturner@shield-legal.com)
2024-10-09 15:58:15

thank you!

James Turner (jturner@shield-legal.com)
2024-10-09 16:01:31

And what does PROD mean on these? I am noticing PROD isn't on the open/closed but for example, the status on CA Juv Hall Abuse - ACTS - FYF - Shield Legal (SmartAdvocate) says Leadspedia on

Ahsan (ahsan@shield-legal.com)
2024-10-09 16:03:37

prod dev means if the flow was in a state of production or dev. Implying mapping may be off for dev, prod should have good mappings

👍 James Turner
James Turner (jturner@shield-legal.com)
2024-10-09 17:10:50

For the Firefighting Foam - Miller Matter, do you know if it's the same APIs as the other firefighting foam miller cases? I'm not seeing that case type on api integrations main, but FF - BG- Miller Goldenfarb is there, and they are both on the Open/Close tracker

Ahsan (ahsan@shield-legal.com)
2024-10-09 17:19:48

the fire fighting is different. SOme of them use a platform called lead docket whihc does not use an autho key at all

Ahsan (ahsan@shield-legal.com)
2024-10-09 17:19:55

its all kinds of fubar

James Turner (jturner@shield-legal.com)
2024-10-09 17:21:35

haha- as long as leadership understands that we are swimming upstream on shitcreek, I can work my way through lol

James Turner (jturner@shield-legal.com)
2024-10-09 17:22:00

I worry about looking like a dummy when it seems that every case I open, is broken in one way or another lol

Ahsan (ahsan@shield-legal.com)
2024-10-09 17:23:16

most case pre dwight are kind of fucked. Post dwight seem to be ok. Anything made by the original dev rahat is full on fallout

Ahsan (ahsan@shield-legal.com)
2024-10-09 17:23:40

flows made by the other engineer dwayne or something asre also shit

Ahsan (ahsan@shield-legal.com)
2024-10-09 17:23:59

mike and dwight flows are easy swap or slight tweak since questions may have changed

James Turner (jturner@shield-legal.com)
2024-10-09 17:47:21

Are we gonna be re-opening it? I saw it was set to Prio 1 but the reports/integrations say it was before they were there, and they don't have an intake or api form for it

Ahsan (ahsan@shield-legal.com)
2024-10-09 17:57:47

Campaign is just suspended due to media spend from elections. It could turn on post elections so we should have the function ready if the campaign restarts

James Turner (jturner@shield-legal.com)
2024-10-09 18:02:09

actually- it looks like the definition.json file has all the client field side, but it's our side that's missing bits and pieces

James Turner (jturner@shield-legal.com)
2024-10-09 18:02:56

maybe I can use the client side, and export our intake, find the C-IDs that way'

Ahsan (ahsan@shield-legal.com)
2024-10-09 18:27:57

Yea that can work

James Turner (jturner@shield-legal.com)
2024-10-09 18:42:54

Would of but intake qs are like 116 questions, and only like 50 are on the definition- on the bright side, I got this working

James Turner (jturner@shield-legal.com)
2024-10-09 18:43:31

I think edward made it, but I managed to figure it out lol

get_questions_list - Copy.zip
Ahsan (ahsan@shield-legal.com)
2024-10-22 13:57:14
Ghozland VGA.xlsx
James Turner (jturner@shield-legal.com)
2024-10-22 14:09:54
close_matches_Ghozland_VGA.xlsx
James Turner (jturner@shield-legal.com)
2024-10-22 17:42:16

Hey there, I am talking to few people over here -

It looks like Meadow reached out and they got an email that there was a new client that was meant for the Ghozland_VGA

James Turner (jturner@shield-legal.com)
2024-10-22 17:44:02

Brittany Specifically is aware of it- If you can please reach out

Ahsan (ahsan@shield-legal.com)
2024-10-22 17:45:44

Will do

Ahsan (ahsan@shield-legal.com)
2024-10-22 17:49:48

Hey what’s Brittney’s last name?

James Turner (jturner@shield-legal.com)
2024-10-22 17:52:36

Barnett~

James Turner (jturner@shield-legal.com)
2024-10-22 17:52:43

Shes the Kermit drinking tea

Ahsan (ahsan@shield-legal.com)
2024-10-22 17:52:53

Copy

Ahsan (ahsan@shield-legal.com)
2024-10-24 16:05:04

If you go to express here is a discount code

IMG_7006
James Turner (jturner@shield-legal.com)
2024-10-31 15:30:24
MatchMatic.zip
James Turner (jturner@shield-legal.com)
2024-10-31 15:36:00
Matchmatic.exe
James Turner (jturner@shield-legal.com)
2024-10-31 15:42:24
Ghozland VGA.xlsx
James Turner (jturner@shield-legal.com)
2024-11-04 12:20:12

INFO ABOUT XML TAGS

<https://stackoverflow.com/questions/29596584/getting-a-list-of-xml-tags-in-file-using-xml-etree-elementtree>

James Turner (jturner@shield-legal.com)
2024-11-05 12:26:09

Big update on ACTS stuff- Hold off on Communications for now, but please let me know any campaigns we need info for

Ahsan (ahsan@shield-legal.com)
2024-11-05 12:30:49

Only thing I am doing for acts is that xml parser, integrations should be handled by everyone else right now

👍 James Turner
James Turner (jturner@shield-legal.com)
2024-11-05 12:30:49

all good stuff

James Turner (jturner@shield-legal.com)
2024-11-05 12:30:57

Good to know- ty

James Turner (jturner@shield-legal.com)
2024-11-06 12:05:03

Do we have any test campaigns? I want to test some lawruler api stuff but I don't want to risk breaking things since we don't have any kind of rollback or data backup on lawruler (that I know of??)

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

I dont think we do

James Turner (jturner@shield-legal.com)
2024-11-06 16:41:24

Any word on if we are having the cam meeting today with Dustin and Nick in training?

Ahsan (ahsan@shield-legal.com)
2024-11-06 16:42:02

Cam pushed to 3:30 but likely the meet will be cancelled as their manager meeting is til 4:30 or so

Ahsan (ahsan@shield-legal.com)
2024-11-06 16:42:13

its a mnore wait and see approach currently

Ahsan (ahsan@shield-legal.com)
2024-11-06 16:42:36

money line is on a cancel I hope

James Turner (jturner@shield-legal.com)
2024-11-06 16:43:15

Gotchu- Btw, I'm trying to get a code project set up for Dustin and hitting a 404 error because my api url is wrong. Can you take a look and tell me where I messed up setting it up?

Ahsan (ahsan@shield-legal.com)
2024-11-06 16:43:33

yea send me the stuff

James Turner (jturner@shield-legal.com)
2024-11-06 16:46:16

I'm trying to test just my getcaseleads function to see if it's able to reach out before I potentially break something

LAWRULER FIRE TRANSFER THING.py
Ahsan (ahsan@shield-legal.com)
2024-11-06 16:46:26

meeting got kicked to tomorrow

Ahsan (ahsan@shield-legal.com)
2024-11-06 16:55:07

got a minute for a qucik call?

James Turner (jturner@shield-legal.com)
2024-11-06 16:55:20

Sure thing

Ahsan (ahsan@shield-legal.com)
2024-11-06 16:56:11

*Thread Reply:* can you hear me?

James Turner (jturner@shield-legal.com)
2024-11-06 16:56:32

*Thread Reply:* Nah, and you aren't lighting up like it's picking you up\

Ahsan (ahsan@shield-legal.com)
2024-11-06 17:07:00

*Thread Reply:* def getcaseleads(casetype): """ Fetches leads for a specified case type using SearchInbox. Adjust the endpoint and filters as per actual API requirements. """ response = requests.get( f"{BASEURL}/ApiCases/GetLead", headers=HEADERS, params={"casetype": casetype} ) # Added missing closing parenthesis here response.raiseforstatus() leads = response.json() # Assuming API returns JSON return leads

Ahsan (ahsan@shield-legal.com)
2024-12-10 17:38:36

when you get a chance please send the dumb cartographer code base

Ahsan (ahsan@shield-legal.com)
2024-12-10 18:00:07

@here ⬆️

James Turner (jturner@shield-legal.com)
2025-03-28 16:32:49
bquxjob_45ab5dd0_195deab1ea8.csv
James Turner (jturner@shield-legal.com)
2025-03-28 16:32:57

SELECT statusname FROM tort-intake-professionals.<a href="http://tip_prod_application.io">tip_prod_application.io</a>_tip_lr_status_rates WHERE servicetype = "RET" AND billable = TRUE

Ahsan (ahsan@shield-legal.com)
2025-04-02 14:37:52

Sir what you have said to me today is very upsetting. I am sure you probably feel worse about it but know you will always have the full backing of the cave behind you!

Fbi Fbifam GIF by CBS.gif