Hi Mark. Happy Thursdays. I wanted to get your opinion on this. We found two lead id #s 735315 & 746949 where we have a code in AWS that updates Ryan's system for the financials and it keeps erroring out for those two specific lead ID #s everyday.
We believe it has to deal with maybe null or missing or incorrect, etc data in leadspedia for those two leads. Would you be able to help assist or know someone who may?
Good morning, I will check on those soon and see what I can find
Since I didn't build the code myself I can't say what it does exactly but I know it updates a table that includes new sign ups everyday
If you want more details about the code I can also include Ryan in this chat since he would know more about the "specifics" than I do
no thats okay for now, was just curious of what it normally looks like
I am looking at the leads and see if I can find something weird
I think I might have found what the issue is anyway
My guess is there is a field that is "blank" and the code doesn't want to see a "blank" value for that field (whatever field that is)
Keep me posted if you find anything weird Mark that you think might but the issue
still looking at it, thought I figured it out, but I haven't
Oh okay no worries. I know it might not be a straight forward thing to figure out right away but I appreciate the help
lead 735315 was sold to a contract that does not exist anymore, so that might be the issue. It was sold to PFAS Water Contamination - BG/Douglas London. Two days after I created the contract, we were informed it was "Meadow/Douglas London"
so the coding from leadspedia to Lawruler would be different/incorrect
the second lead though is not the same situation and I am still looking at it
not seeing anything out of the ordinary for lead 746949
Hmm interesting. I wonder if we fix the first one you mentioned above, we can see if 746949 pulls up as an error again if you can't find the issue with it yet
As for 735315 what do you think we can do in leadspedia to fix this you think ?
Since looks like we identified the possible issue but the action to fix it not sure what I can do to help assist
I am not sure because I am unable to modify what contract it is sold to once its completed. Maybe Ryan is able to update manually?
it sold to: PFAS Water Contamination - BG/Douglas London (Military Base Exposure) (TIP) - Contract BG - DGL - 498 - 1779
should be: PFAS Water Contamination - Meadow/Douglas London (Military Base Exposure) (TIP) - Contract DGL - MDW - 567 - 1790
you're welcome
Hi @Mark Maniora how's it going. I wanted to check with you to see if we are setting up or in the process of setting up a contract for this new campaign: San Bernardino Juv Hall - DL - DL - Shield Legal. Looks like we have a sign up on the 12th of July (LR ID: 796446) & I need to allocate contract name along with proper S1 for it so I wanted to get your thoughts on this
I don't think so, looks like something might be incorrect. We do have one for DL/FL though
we have a webhook for it: San Bernardino Juv Hall - DL - DL - Shield Legal (GCP - Webhook)
I don't know of anything coming up either for that. I am not sure why we have a case type for that when we don't have a contract?
Yeah I was thinking the same since looks like we have aanother sign up for it on 06/09/2025 with this lead ID: 753806. Both are signed e-sign re-triggered
ask Daniel if he knows anything about it.
I think that might be a mistake. Should be for DL/FL
Okay he said they are a special case and are legit leads for me to reach out to sobo so I shall do that right now lol
and then it looks like it was assigned that case type manually by the agent
Update: Sobo said these came in as referrals so now I shall reach out to Melissa to get her thoughts on this
ahhh ok thanks