Best answer

Action works but a zap says Bargle!

  • 30 May 2020
  • 3 replies
  • 1021 views

Userlevel 1

Hi just trying to create my first actions and zap here so I might be missing something big so bear with me :-)


When creating my action in the UI it looks good and all test just work.

But when I create a Zap out of my action using Google Sheets as a trigger it, it fails with “Bargle. We had trouble getting a matching lookup. :-(” and no logs that can guide me in any meaningful way!

I have no idea where the problem lies..

 

So this is what I have at the moment in few steps to make it clear what I´m doing

 

Steps

  1. My google sheet 
  2. Where I hook that up to my action 
  3. I “Test and Review” with the data my action picks up from the sheet (so that works)

     

  4. And hitting “Test & Review”  I get this… “Bargle. We ad trouble getting a matching lookup. :-(

     

 

What does this mean? Is it on my end, google end or zapier end? Here the UI is massively missing logs...

 

For more information creating my action seems to be just fine like shown below

 

 

where the response is this JSON array 

[

    "341243"

]

 

Because of all my troubles with the UI and its lack of logs, test and power I tried to convert this to an CLI but that’s also broken https://github.com/zapier/zapier-platform/issues/234

 

Hope you can help

icon

Best answer by Sturla 5 June 2020, 10:40

For others hitting this my problem was that the UI validated just fine. My API was returning an array.. BUT

it looked like this

 

[

{

   "123123"

}

]

 

When it needed to have a strongly typed property, or something like this here

 

[

    {

        "id": "4de6dfa0-8f5e-428a-a1ae-313290b054e8",

        "name": "341243",

        "probability": 100

    }

]

 

I hope the UI validation will be fixed so somebody else won’t have this problem.

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +9

Hey in that zap you’re highlight - I know it might seem strange at first when just beginning to use Zapier, but the lookup value is the value you are searching for - So you’re doing a vertical lookup instead of a horizontal one.

If you change this to say “Population” it will find what you’re looking for: 

 

Userlevel 1

hmmm sorry for being totally dense right now… I know that need the “Lookup value” to be in this case “Iceland” and Property Name “Population” for my action to return a value. The lookup value cant be “population” at least.

 

So I think its doing it correctly… picking up a new row where I tell it witch column goes where…

 

See here.

 

Just like what is picked up and shown when I press continue

 

 

Sorry if I’m misunderstanding you but I am finding the UI builder sourly lacking logs of just about any kind!

Userlevel 1

For others hitting this my problem was that the UI validated just fine. My API was returning an array.. BUT

it looked like this

 

[

{

   "123123"

}

]

 

When it needed to have a strongly typed property, or something like this here

 

[

    {

        "id": "4de6dfa0-8f5e-428a-a1ae-313290b054e8",

        "name": "341243",

        "probability": 100

    }

]

 

I hope the UI validation will be fixed so somebody else won’t have this problem.