Tandem API call to mutate elements failed - Spreadsheet data

[aniket_pichakate]

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"}

[jan.liska]

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.

[aniket_pichakate]

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

[jan.liska]

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

[aniket_pichakate]

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.

[jan.liska]

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.