Bridge error: Plugin Error: A required parameter is missing from your request: ids.

System

This discussion was created from comments split from: Bridge: Way to delete all rows in a sheet.

MK_CL

Hello! This post was very helpful to me and I'm certainly getting closer, but I keep running into this error:

• workflow execution failed: Plugin Error INVALID_DATA : failed to execute extension module : A required parameter is missing from your request: ids.

Is this a common error that came up during setup, and if so, is there some obvious error that I could fix?

Paul Newcome

Are you able to provide some screenshots of your runtime data and associated modules?

Genevieve P.

@MK_CL - Sending you a tag notification to make sure you saw Paul's comment on this thread! 🙂

MK_CL

Thanks very much - sure, I've attached a screenshot above. In working with the smartsheet support team, they gave me the suggestion to use {{states.Get Row in an Array.stringtools.replace_text.replacement}} as the Row ID in the Delete Row section, but that returns the same error. I also tried {{states.Get Row in an Array.stringtools.replace_text.replacemnet}}, since that's the actual string I got when following the instructions in the initial post here, but that got me the result you see above.

Thanks @Genevieve P. for the tag!

Paul Newcome

What exactly are you trying to accomplish? I see you are ending on a Delete Row module, so I am not sure where the extract and replace modules are coming into play.

MK_CL

I am trying to set up a workflow to delete rows when they are added to a specific sheet - I have a system in Control Center where there are many separate projects, and issues are submitted via a form and then reviewed in a dashboard. I have set up a system where reviewers can check a box to move any row that needs to be deleted to a "landfill" sheet, where I'd like Bridge to automatically delete it.

Genevieve P.

Hi @MK_CL

Can you show us how you have the "Delete Row" module set up? (In my comment with instructions on the other post, it's the final image.)

MK_CL

Hi @Genevieve P. - yes, of course! Please let me know if you need to see anything else:

The full text is {{states.Get Rows in an Array.stringtools.replace_text.replacemnet}}, and I've also tried it with the last word spelled "replacement"

Genevieve P.

Hey @MK_CL

Thank you for all of the images and for working with us through the details! The typo in the reference is the correct one (replacemnet, haha).

Your Array Management and your String Output look correct as well, from what I can see.

The only thing I can think of is an extra space somewhere that we can't see… perhaps in the RowID field. Can you try manually adding in a row ID into that area instead of the array reference? Just as a test to make sure it works properly.

Then if that works, try triggering it with only 1 row in the sheet. Did that work?

Paul Newcome

If all you need to do is delete a row once it lands on a sheet, why not go straight to the Delete Row module?

The Bridge trigger would be when new rows are added to the landfill sheet. The only module needed would be Delete Row. You already have the sheet ID, and the row ID can be pulled from the trigger's runtime data.

MK_CL

Hi @Paul Newcome and @Genevieve P. - I checked back today, and it's now working correctly! Frankly, I didn't change anything and I'm not sure what happened (Smartsheet support emailed me back this morning to say my source sheet had no rows, and I thought…. I didn't delete any rows! So I checked back and it's now working fine. I added a couple of test rows and they were deleted immediately (see below).

This is a bit of a mystery to me as to how it suddenly got resolved, but I'm not looking this gift horse in the mouth. Thanks so much to both of you for the assistance, I am sure that it was your tips that let me get this straightened out. I really, really appreciate it!

Genevieve P.

@MK_CL

I'm very glad to hear this! Thank you for following-up.