Hi all, I am trying to retrieve the list of locations in Netsuite but it is not giving me the addresses. { "q": "SELECT * from location" } It is only giving the ID of the mainaddress but not the actual address. I tried BUILTIN.DF(mainaddress) but it returns me the address as a string, I want it in JSON format so I can pick the country name. Is there a way to do it?

you need to join to the appropriate table