Hello,
Dynamicly filling the Where Clause in a FeatureReader (Arcgis Online feature Service) only gives an error in Automations.
I want to retrieve notifications (meldingen) of the previous month (maand) of the year (jaar) out of Arcgis Online (on a certain point in a month). I want to put this functionality in an Automation.
I do this using the following steps:
-In an AttributeManager I take the current DateTime; extract the month and year and calculate the prevous month (use conditional value for use in January).
-This values are put in a privat parameter: Maand (month); JAAR(year)
-The private parameter is then used in the where clause.
EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = $(Maand) AND EXTRACT(YEAR FROM "REGISTRATIE_DATUM") = $(JAAR)
This setup works in FME Desktop and on FME Server > (from log)
where 'EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = 7 AND EXTRACT(YEAR FROM "REGISTRATIE_DATUM") = 2021'
When putting the Workspace in aan automation it gives an error > (from log)
where 'EXTRACT(MONTH FROM "REGISTRATIE_DATUM") = AND EXTRACT(YEAR FROM "REGISTRATIE_DATUM") = '
The values for Year and Month are not added according to the log.
My question is what goes wrong here and why does the Workspace give an error in Automations? Is there an alternative?
Regards,