# Need a hand with cloudant node-red dashboard

**URL:** <https://discourse.nodered.org/t/need-a-hand-with-cloudant-node-red-dashboard/8241>\
**Category:** General\
**Created:** [21 February 2019 19:18 UTC](https://discourse.nodered.org/t/need-a-hand-with-cloudant-node-red-dashboard/8241 "2019-02-21T19:18:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryan-ninjamoba](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bryan-ninjamoba/32/21973_2.png) [@bryan-ninjamoba](https://discourse.nodered.org/u/bryan-ninjamoba)\
**Post date:** [21 February 2019 19:18 UTC](https://discourse.nodered.org/t/need-a-hand-with-cloudant-node-red-dashboard/8241/1 "2019-02-21T19:18:37Z")

</div>

Id like to build a standard flow for interfacing with cloudant via the node-red dashboard.

I know there are tutorials to connect and retrieve info via cloudant but I havnt been able to find a comprehensive flow that covers making a free form search from a content field and writing the result back to cloudant, If someone can point me to a more comprehensive flow showing integration with the dashboard to make searches and writes that would be helpful,

Here's what Im trying to do:  
Id like to make freeform searches on the content of the tweets based on 15 minute increments.- aggregate the results and and then write the results back to cloudant with the search terms / average sentiment appended and datestamps in month day year time format.

My cloudant data base was created with the following: msg.payload via tweetnode to cloudant

{ "timestamp" : msg.tweet.timestamp\_ms , "tweet" : msg.tweet.text, "sentiment" : msg.sentiment.score}

so the individual entry written looks like this in cloudant:

{ "\_id": "02e64bcd64333371b617ea174a014bca", "\_rev": "1-428ef3751b91ee0f4d93a8a3087f3592", "timestamp": "1549466344259", "tweet": "Come at meet our team ", "sentiment": 0 }

**not using url nodes** Im building a node-red interface using message.payload in .json directly to cloudant to manage and manipulate this info via dashboard. Which cloudant node is best for this non-use of urls?

Can I get a hand with likely data structures, msg.payloads and search strings to pass to the cloudant node via node-red and dashboard msg.payload

during the process my goal is to parse the data into the largest chucks for tonal analysis and also include so the returned/written result back to cloudant would be  
{ date\_range\_in\_15\_minute\_increments : date/time fuzzy\_search\_term: found\_term(s)  
aggregated\_text : english\_text\_stripped\_of\_hashs\_and\_urls average\_sentiment\_in\_period  
avg\_sentiment\_score\_in aggregated\_range average\_tone\_in\_period :avg\_single\_tone\_of\_aggregated\_text}