Java call not returning author.email, but the studio api browser does
I am doing an api call with a java client and executing the following query using api v2:
SELECT id, body, view_href, subject, author.email FROM messages WHERE replies.count(*) = 0 AND depth = 0
When I look at the author.email field it comes back empty. If I do the same query in the studio api browser the email is returned. Can anyone think of why this would happen? All the other values are coming back.
api browser:
{
"status" : "success",
"message" : "",
"http_code" : 200,
"data" : {
"type" : "messages",
"list_item_type" : "message",
"size" : 1,
"items" : [ {
"type" : "message",
"id" : "58",
"view_href" : "/t5/Welcome-Board/asdsada/m-p/58#M36",
"author" : {
"type" : "user",
"email" : "blah@blah.com"
},
"subject" : "asdsada",
"body" : "<P>asdasdasdasd</P>"
} ]
},
"metadata" : { }
}
java code:
{
"metadata":{
},
"http_code":200,
"data":{
"size":1,
"list_item_type":"message",
"type":"messages",
"items":[
{
"author":{
"type":"user",
"email":""
},
"subject":"asdsada",
"id":"58",
"href":"/messages/58",
"type":"message",
"body":"<P>asdasdasdasd<\/P>",
"view_href":"http://stage-community.zuora.com/t5/Welcome-Board/asdsada/m-p/58#M36"
}
]
},
"message":"",
"status":"success"
}