GoogleChronicle_Is Value In Reference List

Hey @mccrilb ,

Can you showcase some examples of when it wasn't working as expected? Thanks

Yes, give me a few. We did find that using GoogleChronicle - Get Reference Lists and using the Expanded Details did work.  But finding where all of these functions are in the playbooks and updating them would be a massive pain. 

Manual Action

List

Result

I uploaded an example. I tried with the Case on and off, and I  tried a regex version. It just seems like this function no longer works.

I also did open a case.  59074004

Thanks @mccrilb . Will check internally and get back to you!

Hey @mccrilb ,

I've tried to reproduce the same situation as you did, but for me it works as expected. Can you check, if you get any errors in the logs, when running the action from IDE?

from the IDE

Testing View

Could there be something corrupt with the lists themselves? I created a new list and tested, and it worked.

@mccrilb Very hard to tell, never encountered anything like that. 

Did you have a situation, where you created a list with "User_Titles" name, then deleted it and then created again a reference list with the same name?

No, I never deleted it, it has been added to though. So I just tried this,

1. I created a new list, and the lookup function worked.

2. I then added a new item to the same list, and now the lookup does not work.

I've tried this example, but for me it still works as expected. Did you add some special value into the list?

I created a second list, and I have tried several times to modify it, but it just seems to work. 

I do not know why this is so inconsistant

Example _this list works

is list does NOT work

I just created both of those lists today.

it seems like once breaks....

I copied the function and put a couple of print statements in. the function does return the values from the list. 

It looks to me like the /r is the issue. I searched for the last value in the list and it found it. 

I ran against one of the lists that work, and sure enough, the return of the list does not contain /r 

@mccrilb Thanks for investigation.

I will add a task for the team to ignore "\\r\\n" characters, if they are at end of the string.

Curious to understand, how you got them? Were you copying from some place and during this process "\\r" character was added as well? Is that how it happened?

I have copied and pasted at times. It looks like, though, once that shows up,  it will show up every time, even when you add via the keyboard.