Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • How can I send batches , for example, 5 rows from the database (SQL non-Spatil) and send to a JSONTemplater and repeat this process?

Hi,

 

I am new to the FME desktop.

 

I am reading data, for example, 10 rows from my database (SQL non-spatial) transforming it to JsonTemplater and sending it via HTTPCaller. It is working fine.

 

Therefore, there is a constraint to sending only batches of 100 rows per JSON file.

 

I have already tried the decelerator but the decelerator only delays the rows.

 

Could somebody help me?

 

Thanks

 

Raphael Yamada

Check out the GroupBy option in the JSON templator

imageIf you can make sure each 'batch' of features have an attribute with a shared group id/name then the JSONTempator will process the features coming in in batches.

You'll also need one root feature per batch/group as well (this should also share the same group id as the batch of users

Thanks,

You gave me a great idea to separate into groups and count. I used the transformer "GroupCounter" and it worked. Thanks for helping me.

Thanks,

You gave me a great idea to separate into groups and count. I used the transformer "GroupCounter" and it worked. Thanks for helping me.

Excellent solution, nice

Reply


Community Stats

30,160
Posts
114,491
Replies
37,812
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.