Looking for someone with good knowledge in Python, json, API, Big Query etc.
Timeline: 1 to 2 day.
1) Table schema in BQ:
Field name Type Mode
Date DATE NULLABLE
Item STRING NULLABLE
cost FLOAT NULLABLE
2) Query used to get the data:
Select date, Item, sum(cost) as cost
Group by date, item
Pull the big query data and convert it to json with group by ”date”.
I will provide the sample output which I needed
Hello, I have read your requirements. I can convert your data to json through api using python. I can complete this project in an hour. Let know if you are interested. Thank you.
7 freelancers are bidding on average $36 for this job
I am good in powershell, api, query along with automation and development, i can help you to write script with powershell Please let me know if you are good to award this project to me