从api保存到s3 bucket



我正在尝试使用bot03和python获取下面的python代码,以将csv从api保存到amazon s3 bucket,但我看不出哪里出了问题。当我执行代码时,我没有得到任何错误,但该文件从未出现在s3存储桶中。

import boto3
from botocore.exceptions import ClientError
file_name = "test.csv"
bucket = "mybucket"
def main():
url = "https://api0.solar.sheffield.ac.uk/pvlive/v3/pes/10?start=2021-01-01T00:00:00&end=2021-07-06T00:00:00&data_format=csv"
x = requests.get(url,headers={'Content-Type': 'application/json', 'Accept': 'application/json', 'Accept-Encoding': 'gzip, deflate',})
s3 = bot03.client("s3")
with open("test.csv","rb") as file2:
s3.upload_fileobj(x.content, bucket, "test.cvc")

任何提示/建议都将不胜感激。我是一个python/aws新手,所以很抱歉如果有一个基本问题

我用这段代码获得了我需要的

file_name = "test.csv"
bucket = "my_bucket"
def main():
url = "https://api0.solar.sheffield.ac.uk/pvlive/v3/pes/10?start=2021-01-01T00:00:00&end=2021-07-06T00:00:00&data_format=csv"
x = requests.get(url,headers={'Content-Type': 'application/json', 'Accept': 'application/json', 'Accept-Encoding': 'gzip, deflate',})

s3_resource = boto3.resource('s3')
s3_resource.Object(bucket, 'snowflake/csv/df1.csv').put(Body=x.content)

if __name__ == "__main__":
main()

根据OP(原始帖子(,你试过吗

(第11行(s3=boto3.客户端("s3"(-OP:bot03.客户端("s3"(

最新更新