Not sure this was a thingโฆ
So Iโm trying to fix an issue with a bot using the Appsheet API. The API calls an action and the action creates a row in a table. Action type = set the values of some columns in this row.
The issue is I want to specifiy the key column within that action. Butโฆ you canโt. It seems once a key column is populated, it becomes Read Only, irrespective of any rules for that column. So if I add the key column to the action I get:
The column โContactIDโ of data action โTestAction3โ cannot be modified.
Any ideas
Yes, always.
Iโm not clear what youโre trying to do. Why are you trying to edit the key value?
Thatโs the wrong Action type for creating a row.
Hi @Marc_Dillon yeah I know. But I was trying to diagnose the issue with this from yesterday:
and then today I read this:
which says:
You can only invoke the following types of actions from the API:
Data: set the value of a column
Grouped: execute a sequence of actions
All actions invoked in the grouped sequence must be either Data: set the value of a column or Grouped: execute a sequence of actions .
My origional action was a โAdd a new row to another table using data form this rowโ so I created a โset the values of some columns in this rowโ action to see if this was the culprit.
Iโm very confused what your goal here is, sorry
If you still are having issues from the old thread, does it make more sense to continue posting there?
If youโre trying to add a new record via API, maybe just use Add via API, not invoke an Action?
Yah, thatโs news to me, but it makes sense for the most part.
Iโm curious though, this article was certainly written before some of the newer Actions were created, like โadd a new row with values from this rowโ. Perhaps it was never updated. I would do tests to make sure you canโt use that Action.
I just tested this for you.
Action type โdata: add a new row to another tableโ successfully executed via an API invoke an Action call.
Action type โexecute an action on a set of recordsโ does NOT work, returns error:
"Action of type 'REF_ACTION' for table 'parent' is not supported for the REST API."
@Steve, Could you update the doc linked above, to include the โAdd a new rowโ Action type. Or, even better, find someone who knows more about this to properly/completely update this doc? Or I can submit a support ticket if thatโs better.
Strange then that Iโm not even seeing that error message
Sorry, the error wasnโt returned via API response, it was in the Audit Log.
Edit to the above.
The โexecuteโ Action that I tried to invoke, was just simply to run the same โadd a new rowโ Action from before it, on the same Table.
I made a new โgroupedโ Action, and just had it run the โexecuteโ Action, and invoked it by the API, and it worked just fine.
i.e. API canโt run an โexecuteโ Action, but it can run a โgroupedโ Action that in turn runs the โexecuteโ Action.
So just wrapping it in a group action works?
Apparently.
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |