Parse a Json file via an API from monday Table

Yes, you can do that using the API.

Here is the API reference on how to update a number column.

Automations cannot be modified through the API yet.

Thanks for this quick answer, I’ll review this documentation !

Is it possible to call an API directly from a number Column, or we can only push from an API like with POST method ?

You can update and read from your board using the API. To react to changes on your board, you will to use an integration. You can read more about integrations here

I was not clear in my first demand perhaps, I’m just looking for fill a number column (Or a text column) with values I can parse in a JSON called from an external public API

I have the URL with the query, this URL return the JSON file and I want to display in the number/text column the value I’m looking for :

Then it display the parsed value.

I’m not sure it’s possible to handle READ method directly with the board, let me know.

Thanks in advance for your answer

It is not possible to “to handle READ method directly within the board”. To update the board programmatically, you will have to use the API.
To update a particular item, you will first have to get the board and item id. Using those ids, you can then update the number value for that item.
Here is an example from the documentation.

So for your task, the steps will look something like this:

1. Get board, item and Link and Number column ids
2. Parse the data from the link column for that item
3. Make the request and obtain the result number value
4. Update the Number column (using the example documentation link posted above) with the number value obtain from the request

Understood, so I need to code and run a script on my own for parsing a json and the push an update, am I right ?

Yes. That is correct

Thanks a lot ! I’ll try this !

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.