# troubleshooting

Piyush Bajaj

04/06/2022, 8:01 AM
Hey Team , I have a concern .I am moving the data from MongoDB to BIgquery and all the nested columns are there in the raw table but the final table the values are null .I tried this same in the month of December at that time the json objects were coming in the string format but now it is coming blank .Can anyone help me to resolve this .
@Parth Gangrade
I actually figured out the json values which are of structure type are getting captured by the json_extract function and not by json_extract_scalar function.How can i change the json_extract_scalar by json_extract in the code ?

Marcos Marx (Airbyte)

04/07/2022, 6:34 PM
Hi there! Thank you for your time posting in our Slack Channel. This week we’re moving our support discussions over to; if you would be so kind as to post your questions there, you’ll be able ask for help from fellow users as well as the Airbyte team. It is our intention that as of Friday afternoon (Pacific Time) we will lock this channel to everything except administrator posts. We’ll leave everything in place for the rest of April if you need to get information or troubleshooting from existing threads, with the intention of archiving the channel in early May. We really appreciate everyone helping us to build our community, and we’re looking forward to the next phase.