topic Re: Tandem API call to mutate elements failed - Spreadsheet data in Tandem Forum

Tandem API call to mutate elements failed - Spreadsheet data

aniket_pichakate — Mon, 12 May 2025 09:36:52 GMT

Hi There,

I' am trying to update & insert spreadsheet data in tandem using AU tandem service plugin receiving exception about..

Error: Tandem API call to mutate elements failed.
Cause: {"title":"Bad Request","detail":"invalid value (Value conversion failed for type 40 and value Working\n) at 3"}

Re: Tandem API call to mutate elements failed - Spreadsheet data

jan.liska — Mon, 12 May 2025 13:32:26 GMT

Hello, looks like you're trying to set property Operational Status with value of Working but this value isn't specified in the list of allowed values for this parameter. Can you use Manage tab - Parameters if the value is there, pls? Check out attached example.

Re: Tandem API call to mutate elements failed - Spreadsheet data

aniket_pichakate — Mon, 12 May 2025 13:45:15 GMT

I want to see those details under Gerneral category similar to airtable example. following steps mention in attach document of spreadsheet.

Re: Tandem API call to mutate elements failed - Spreadsheet data

jan.liska — Mon, 12 May 2025 13:54:26 GMT

Yes, this is possible. You can control this using Category option when creating/editing parameter:

Re: Tandem API call to mutate elements failed - Spreadsheet data

aniket_pichakate — Mon, 19 May 2025 05:25:18 GMT

I'm trying to update operational data from spreadsheet, there i m facing issue while mapping information in parameter fields. I am certain that issue comes from tandem services plugins.

Re: Tandem API call to mutate elements failed - Spreadsheet data

jan.liska — Mon, 19 May 2025 08:02:03 GMT

You may want to check logs tab of the node what value you're sending to Tandem. Typically reason for this error is that you're trying to send value of different type. In case that you want to set text value make sure it's listed in the list of allowed values for specific parameter. Note this is case sensitive.