Skip to main content

GoogleChronicle_Is Value In Reference List

  • April 22, 2025
  • 25 replies
  • 55 views

mccrilb
Forum|alt.badge.img+12

This function no longer seems to be working correctly. We use this in several playbooks all of which are no longer functioning correctly.

25 replies

ylandovskyy
Staff
Forum|alt.badge.img+16
  • Staff
  • April 22, 2025

Hey @mccrilb ,

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


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 22, 2025

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. 


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 22, 2025

Manual Action


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 22, 2025

List


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 22, 2025

Result


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 22, 2025

Hey @mccrilb ,

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


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.


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 22, 2025

Hey @mccrilb ,

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


I also did open a case.  59074004


ylandovskyy
Staff
Forum|alt.badge.img+16
  • Staff
  • April 22, 2025

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


ylandovskyy
Staff
Forum|alt.badge.img+16
  • Staff
  • April 23, 2025

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?

 


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

from the IDE


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

Testing View


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

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


ylandovskyy
Staff
Forum|alt.badge.img+16
  • Staff
  • April 23, 2025

@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?


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

@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.


ylandovskyy
Staff
Forum|alt.badge.img+16
  • Staff
  • April 23, 2025

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?


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

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


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

Example _this list works


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

is list does NOT work


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

I just created both of those lists today.


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

it seems like once breaks....


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

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


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

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


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 23, 2025

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


ylandovskyy
Staff
Forum|alt.badge.img+16
  • Staff
  • April 24, 2025

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?


mccrilb
Forum|alt.badge.img+12
  • Author
  • Silver 2
  • April 24, 2025

@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.