ColdFusion CFHTTP处理从API返回的数据

dknighton

我刚刚开始使用Rotten Tomatoes API来检索电影信息,并且我需要一些帮助来理解如何处理返回的数据。这是我第一次使用这样的API,因此如果听起来很基础,请原谅我。

使用cfhttp可以成功连接到API并返回搜索数据,但是我真的不知道我返回的格式是什么。我以为是JSON,但使用isJSON进行检查会返回false。我希望能够调用返回数据中的各个字段来填充查询结果集,然后将其输出给用户。

我用来进行调用的代码很简单:

<cfhttp url="#apiURL#movies.json?apikey=#apiKey#&q=#movieName#" method="get" result="httpResp" timeout="120">
    <cfhttpparam type="header" name="Content-Type" value="application/json" />
</cfhttp>
<cfdump var="#httpResp#" />

以及返回的数据:

这是返回数据时的样子

我不希望有人能完全向我介绍如何构建我的应用程序,但是如果有人能给我一些有关将数据转换为查询结果的正确方法的指示,或者我可以使用的其他方法,我会很感激。

编辑:没意识到图像很难阅读,所以这里是对返回数据的剪切和粘贴。

{"total":2,"movies":[{"id":"11029","title":"Krull","year":1983,"mpaa_rating":"PG","runtime":120,"release_dates":{"theater":"1983-07-29","dvd":"2001-04-03"},"ratings":{"critics_rating":"Rotten","critics_score":33,"audience_rating":"Spilled","audience_score":49},"synopsis":"","posters":{"thumbnail":"http://content6.flixster.com/movie/25/86/258696_mob.jpg","profile":"http://content6.flixster.com/movie/25/86/258696_pro.jpg","detailed":"http://content6.flixster.com/movie/25/86/258696_det.jpg","original":"http://content6.flixster.com/movie/25/86/258696_ori.jpg"},"abridged_cast":[{"name":"Ken Marshall","id":"162668719","characters":["Prince Colwyn"]},{"name":"Lysette Anthony","id":"162668720","characters":["Lyssa"]},{"name":"Freddie Jones","id":"162664678","characters":["Ynyr"]},{"name":"Francesca Annis","id":"162688297","characters":["Widow of the Web"]},{"name":"Alun Armstrong","id":"770670461","characters":["Torquil"]}],"links":{"self":"http://api.rottentomatoes.com/api/public/v1.0/movies/11029.json","alternate":"http://www.rottentomatoes.com/m/krull/","cast":"http://api.rottentomatoes.com/api/public/v1.0/movies/11029/cast.json","clips":"http://api.rottentomatoes.com/api/public/v1.0/movies/11029/clips.json","reviews":"http://api.rottentomatoes.com/api/public/v1.0/movies/11029/reviews.json","similar":"http://api.rottentomatoes.com/api/public/v1.0/movies/11029/similar.json"}},{"id":"770670060","title":"Bekenntnisse des Hochstaplers Felix Krull (Confessions of Felix Krull)","year":1957,"mpaa_rating":"Unrated","runtime":107,"release_dates":{"theater":"1958-03-04"},"ratings":{"critics_score":-1,"audience_rating":"Spilled","audience_score":33},"synopsis":"","posters":{"thumbnail":"http://content7.flixster.com/movie/10/84/16/10841649_mob.jpg","profile":"http://content7.flixster.com/movie/10/84/16/10841649_pro.jpg","detailed":"http://content7.flixster.com/movie/10/84/16/10841649_det.jpg","original":"http://content7.flixster.com/movie/10/84/16/10841649_ori.jpg"},"abridged_cast":[{"name":"Horst Buchholz","id":"162718595","characters":["Felix Krull"]},{"name":"Liselotte Pulver","id":"326392065","characters":["Zaza"]},{"name":"Ingrid Andree","id":"770670669","characters":["Zouzou"]},{"name":"Susi Nicoletti","id":"770670670","characters":["Madame Houpfle"]},{"name":"Paul Dahlke","id":"573372814","characters":["Professor Kuckuck"]}],"alternate_ids":{"imdb":"0050179"},"links":{"self":"http://api.rottentomatoes.com/api/public/v1.0/movies/770670060.json","alternate":"http://www.rottentomatoes.com/m/bekenntnisse-des-hochstaplers-felix-krull-confessions-of-felix-krull/","cast":"http://api.rottentomatoes.com/api/public/v1.0/movies/770670060/cast.json","clips":"http://api.rottentomatoes.com/api/public/v1.0/movies/770670060/clips.json","reviews":"http://api.rottentomatoes.com/api/public/v1.0/movies/770670060/reviews.json","similar":"http://api.rottentomatoes.com/api/public/v1.0/movies/770670060/similar.json"}}],"links":{"self":"http://api.rottentomatoes.com/api/public/v1.0/movies.json?q=Krull&page_limit=30&page=1"},"link_template":"http://api.rottentomatoes.com/api/public/v1.0/movies.json?q={search-term}&page_limit={results-per-page}&page={page-number}"}

编辑:谢谢,丹。那是我所需要的。了解了如何获取JSON数据后,我能够找到以下有关如何将其转换为有用查询的说明:在CF中使用远程API JSON数据

和布拉库克

文件内容看起来像json。您可以通过使用它来引用它

#httpResp.filecontent#.

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

使用 ColdFusion cfhttp 连接到远程 API

来自分类Dev

Coldfusion返回JSON数据

来自分类Dev

从ColdFusion中的REST API返回JSOn数据

来自分类Dev

Coldfusion 自动保存数据

来自分类Dev

Coldfusion WCF API实现

来自分类Dev

Coldfusion WCF API实现

来自分类Dev

时髦的API与Coldfusion

来自分类Dev

使用使用ColdFusion返回JSON数据的SOAP API

来自分类Dev

在ColdFusion中作为响应返回JSON数据

来自分类Dev

Twitter API在ColdFusion中返回401

来自分类Dev

Coldfusion电子邮件处理

来自分类Dev

Coldfusion电子邮件处理

来自分类Dev

ColdFusion查询页面返回JSON

来自分类Dev

ColdFusion组件不返回查询

来自分类Dev

在ColdFusion中使用JSON数据

来自分类Dev

带有ColdFusion的DocuSign API

来自分类Dev

ColdFusion REST API启用CORS

来自分类Dev

ColdFusion 10 REST API:返回文件时调用站点范围的错误处理程序(AbortException)

来自分类Dev

Coldfusion将cfhttp.filecontent解析为列表

来自分类Dev

ColdFusion无法在cfhttp调用之间维护会话

来自分类Dev

使用Coldfusion处理Mailgun的传入邮件

来自分类Dev

使用Coldfusion处理Mailgun的传入邮件

来自分类Dev

coldfusion cfquery返回插入的oracle rowid

来自分类Dev

ColdFusion JSON以特定格式返回

来自分类Dev

如何解析ColdFusion CFC返回的JSON?

来自分类Dev

coldfusion自定义标签返回变量

来自分类Dev

如何解析ColdFusion CFC返回的JSON?

来自分类Dev

使用jQuery返回css格式的coldfusion结果

来自分类Dev

ColdFusion JSON以特定格式返回