a_ericsson wrote:
Hey, thanks! My problem, if I have understood this correctly, would be that I would have to specify the .gpkg file many times over. As I will run the script probably on a weekly basis a new file with a new folder name will be downloaded each time, which would make the specified path obsolete. The total output is around 80 tables in the postgis database, so specifying the files manually would be very time-consuming, which is what I'm trying to avoid :) I might be missing something obvious..
If the 80 or so table names are the same each week you can set Feature Types to Read and Output Ports only when you first set up FeatureReader (by selecting your .gpkg file). Most of the time API's don't change over time 😀
The path should come in as an attribute (_response_file_path attribute from HTTPCaller or path_windows from ZipExtractor) so you don't have to worry about that.
Or, another way to explain it, the first time you set FeatureReader you use a .gpkg file downloaded from the API that is already stored on your disk, then you change Dataset to an attribute that contains the file path. The settings should stay the same by default. If not, use that .gpkg file to set Feature Types to Read and Output Ports -> Specified after you changed the Dataset parameter to an attribute value.
If this is not the case, please give us some more info about the API response and the schema(s) of the .gpkg file(s).
