• 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?
Question

How can I send batches , for example, 5 rows from the database (SQL non-Spatil) and send to a JSONTemplater and repeat this process?

yamadar
Rank

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

1 Attachment

3 replies

virtualcitymatt
Rank
Userlevel 4
Badge +26

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

yamadar
Rank

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.

1 Attachment
virtualcitymatt
Rank
Userlevel 4
Badge +26

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

28,661
Posts
109,318
Replies
36,528
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.