My main problem is to call an api for each row in a table in dataverse.
I wanto to add a new column to one of my table dataverse. This column shoud be a mandatory entry for all the rows.
For whe rows that i will add after this change will not be a problem to put the value in it since this filed is linked to a table B in the dataverse and will let the user select one of the value available in the key column af the table B.
For the old records this is a bit more difficult because the new value needs to be setted in an automatic way to a value. I wa thinking about the possibility to make a function for each row that passes a data and get in response the new value that will be saved in the new column.
For example: i have a table with a column named CITY but i want the table to store also the COUNTRY of this city.
I will create a column name COUNTRY and make it searchable with a set of option given by another table called City-Country.
At the same time a function in every old row will be called and given a city it will make an http request to an api to retrieve the country where the city is located and the name of the country will be aseve in the correct row that called the api.
Is this something feasible? How could I do it? are there other way to do something like this?
My main problem is to call an api for each row in a table in dataverse. For the api i think i can do one myself
