How to take only the latest data from an API that updates every week?

One idea would be to create an attribute “CurrentWeek” and then you can run the data through a Tester, Passing only the data which has a “temporal” value that equals the “CurrentWeek”. You could create this “CurrentWeek” attribute a couple of ways.

You could use a DateTimeStamper and DateTimeConverter, with the output format %Y-W%U.

Alternatively you could create that attribute in an AttributeCreator or AttributeManager by setting the value to

@DateTimeFormat(@DateTimeNow(),%Y-W%U)

.

If you are able to, you can create this attribute beforehand and use it to only read the data that matches that attribute.

Thanks Im new to FME so this is very helpful.

I understand correctly that this attirbute should change by itself every week?

Yes, the attribute created using the dedicated DateTimeStamper transformer or the “@DateTimeNow()” method will keep up to date with the current week. Both methods get the current date and time when they run, and then the formatting part changes it to only display the year and week.