首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >如何使用节点访问Azure表存储API -Red HTTP请求节点

如何使用节点访问Azure表存储API -Red HTTP请求节点
EN

Stack Overflow用户
提问于 2019-09-23 22:12:02
回答 1查看 236关注 0票数 0

我正在尝试访问Node-Red中的消息/数据并将其存储到现有的Azure表存储表中。我正在使用为Azure存储帐户配置的指定SAS-token。我可以在PostMan中毫无问题地运行GET请求,但是在Node-Red中尝试完全相同的内容/query string URL时,它会在使用的Atom格式上创建一条错误消息。

我使用一个带有SAS-token的URL (如下图所示)来访问Postman中的表数据:

代码语言:javascript
运行
复制
https://iotcdatastorage.table.core.windows.net/Table1?sv=2018-03-28&ss=t&srt=sco&sp=rwdlacu&se=2019-09-23T20:04:34Z&st=2019-09-23T12:04:34Z&spr=https&sig=a3LSLWu0yVUqzLVaI3S9yL6ZO3acFf8XIBTCHUhglD8%3E. 

它在Postman中运行良好,返回200OK响应代码。

当在Node-Red HTTP请求节点中使用相同的URL时,它会创建如下错误:

代码语言:javascript
运行
复制
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><code>AtomFormatNotSupported</code><message xml:lang="en-US">Atom format is not supported.RequestId:149acccd-b002-0041-6b18-72159a000000Time:2019-09-23T14:09:38.7798256Z</message></error> 

这是什么Atom格式?为什么请求可以在Postman中工作而不能在Node-Red中工作?我可以用格式化或相关的标题来解决这个问题吗?

EN

回答 1

Stack Overflow用户

发布于 2019-09-25 14:40:52

这花了我一些时间,但在我读完之后我就明白了。

我已经附上了工作节点-红色流程供您参考:

[{"id":"f87e7bab.1b7b68","type":"inject","z":"96dd1da4.97f65","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":220,"y":120,“wire”:[“b301afc2.5e844”]},{"id":"1a565e01.dc29b2","type":"debug","z":"96dd1da4.97f65",“name”:“取回表条目”,"active":true,"tosidebar":true,"console":true,"tostatus":false,"complete":"payload.value","x":810,"y":120,"wires":[]},{"id":"b301afc2.5e844",“type”:“更改”,"z":"96dd1da4.97f65","name":"Set Headers","rules":{"t":"set","p":"headers","pt":"msg","to":"{}","tot":"json"},{"t":"set","p":"headers.content-type","pt":"msg","to":"application/json","tot":"str"},{"t":"set","p":"headers.accept","pt":"msg",“to”:“应用程序/json;odata=nometadata","tot":"str"},"action":"","property":"","from":"","to":"","reg":false,"x":410,"y":120,“wire”:[“764f1dd1.c44564”]},{"id":"764f1dd1.c44564","type":"www-request","z":"96dd1da4.97f65","name":"","method":"GET","ret":"obj","url":"https://iotcdatastorage.table.core.windows.net/Table1?sv=2018-03-28&ss=t&srt=sco&sp=rwdlacu&se=2019-09-26T13:35:37Z&st=2019-09-24T05:35:37Z&spr=https&sig=7ogTJRILvYLKce%2B5aiePdBJ%2BXys4pc5%2FH8DmbgBvovk%3Z","follow-redirects":true,"persistent-http":true,"tls":"","x":590,"y":120,“wire”:[“1a565e01.dc29b2”]},{"id":"f62f1d4e.52b8a","type":"comment","z":"96dd1da4.97f65",“name”:“检索添加Azure表存储表”,“info:”“,"x":330,"y":60,“wire”:[]},{"id":"cd48e5e9.beeac8","type":"inject","z":"96dd1da4.97f65","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":220,"y":160,“wire”:[“31d9e715.0cb738”]},{"id":"ad13b55b.042e78","type":"change","z":"96dd1da4.97f65","name":"Set Headers","rules":{"t":"set","p":"headers","pt":"msg","to":"{}","tot":"json"},{"t":"set","p":"headers.content-type","pt":"msg",“to”:“应用程序/json”,"tot":"str"},{"t":"set","p":"headers.accept","pt":"msg",“to”:“应用程序/json”;odata=nometadata","tot":"str"},"action":"","property":"","from":"","to":"","reg":false,"x":590,"y":160,“wire”:[“81917f33.acfa5”]},{"id":"81917f33.acfa5","type":"www-request","z":"96dd1da4.97f65","name":"","method":"POST","ret":"obj","url":"https://iotcdatastorage.table.core.windows.net/Table1?sv=2018-03-28&ss=t&srt=sco&sp=rwdlacu&se=2019-09-26T13:35:37Z&st=2019-09-24T05:35:37Z&spr=https&sig=7ogTJRILvYLKce%2B5aiePdBJ%2BXys4pc5%2FH8DmbgBvovk%3Z",“跟随重定向”:true,"persistent-http":true,"tls":"","x":770,"y":160,“wire”:[“29f660c6.3c1b”]},{"id":"29f660c6.3c1b","type":"debug","z":"96dd1da4.97f65",“name”:“添加表项”,"active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":960,"y":160,“wire”:[]},{"id":"31d9e715.0cb738","type":"function","z":"96dd1da4.97f65","name":"Add RowKey","func":"var today = new Date();\n日期事件= today.toISOString();\n\nmsg.payload = \n {\n \“分区键\”:partitionKeyString,\n \“行键\”:日期事件,\n\“振动\”:值,\n\“运行\”:是/否\n}\n\n返回消息;“,”输出“:1,"noerr":0,"x":410,"y":160,”wire“:[”ad13b55b.042e78“]}]

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/58064383

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档