Groovy JsonBuilder not including collection

Question

I have the following code:

    def customers = Customer.findAll()
    def json = new JsonBuilder()
    json {
        customers.each { customer ->
            id customer.id
            name customer.name
            address customer.address
        }
    }

I'm expecting that the result is an json array of customers, but instead it only contains 1 customer. Note the customers list contains 2 elements.

I saw some other post mentioning to use something like:

customers.collect { 
    Customer c -> [id: c.id, name: c.name, address: c.address]
}

But this style does not really fit nicely in the builder. E.g. I have to use colons : to assign values.

Is there another approach without creating groovy objects?

score 0 · Answer 1 · edited Jul 16 '14 at 00:00

0

No, json is a map, and you need a list of maps. What you are doing with each is re-assigning the id, name and address fields, so you just get the last value.

So you need to collect a list of maps together as you have in the question.

edited Jul 16 '14 at 00:00

dmahapatro

49,365
7
88
117

answered Jul 15 '14 at 22:16

tim_yates

167,322
27
342
338

Yes I think so. But as I mentioned I have to mix style. I was hoping there was a way to avoid this. – Marcel Overdijk Jul 16 '14 at 05:31

score 0 · Answer 2 · answered Jul 15 '14 at 23:54

0

What you need is just this.

def json = new JsonBuilder( customers )

if there are no additional item in customer that is not required in the json.

answered Jul 15 '14 at 23:54

dmahapatro

49,365
7
88
117

No there are more fields and some of them should be excluded. – Marcel Overdijk Jul 16 '14 at 05:29
Then you need `collect` as mentioned in the question and indicated by Tim. BTW is this only Groovy or is it a Grails app you are working on? – dmahapatro Jul 16 '14 at 05:42
Not Grails. Spring-Boot MVC using Groovy. – Marcel Overdijk Jul 16 '14 at 07:33

Groovy JsonBuilder not including collection

2 Answers2