Found 8 arguments.
Found web service url: http://localhost/StockAnalyticsPhpWebSvc/websvc.php
Found key: articleCount
Found var: 1
Test Db On: true
Service Test Db On: true
Fake Data On: false
Ms News Srch Service Fake Data On: false
Ms Txt Snt Service Fake Data On: false
Yh Stock Quote Service Fake Data On: false
Running command 1
Table: intake: 
1) Daily News Intake
Table: targetsymbols: 
7) Get All Active Records
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSymbolsGetAllActive", "params" : ""}
{"data":[{"id":43,"0":43,"symbol":"MSFT","1":"MSFT","company_name":"Microsoft Corp","2":"Microsoft Corp","timestamp":"2016-10-04 23:20:35.594793-04","3":"2016-10-04 23:20:35.594793-04","active":1,"4":1},{"id":44,"0":44,"symbol":"FB","1":"FB","company_name":"Facebook Inc","2":"Facebook Inc","timestamp":"2016-10-04 23:20:35.673095-04","3":"2016-10-04 23:20:35.673095-04","active":1,"4":1},{"id":45,"0":45,"symbol":"AAPL","1":"AAPL","company_name":"Apple  Computer Inc","2":"Apple  Computer Inc","timestamp":"2016-10-04 23:20:35.753793-04","3":"2016-10-04 23:20:35.753793-04","active":1,"4":1}]}
Found Entry Count: 3
Table: otherrpc: 
14) List Variables
Pos: 1 Key: targetsymbols:7 Type: class org.json.simple.JSONArray
Pos: 2 Key: articleCount Type: class java.lang.String
Found symbol: MSFT with id: 43
Table: targetsearchtext: 
13) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "43"}}
{"data":[{"id":69,"0":69,"target_symbols_id":43,"1":43,"search_text":"Microsoft Surface","2":"Microsoft Surface","timestamp":"2016-10-04 23:20:35.910295-04","3":"2016-10-04 23:20:35.910295-04","active":1,"4":1},{"id":70,"0":70,"target_symbols_id":43,"1":43,"search_text":"Microsoft Office 365","2":"Microsoft Office 365","timestamp":"2016-10-04 23:20:35.984854-04","3":"2016-10-04 23:20:35.984854-04","active":1,"4":1},{"id":71,"0":71,"target_symbols_id":43,"1":43,"search_text":"Microsoft Azure","2":"Microsoft Azure","timestamp":"2016-10-04 23:20:36.060319-04","3":"2016-10-04 23:20:36.060319-04","active":1,"4":1}]}
Found Entry Count: 3
Found search text: Microsoft Surface with id: 69
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Microsoft+Surface&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Microsoft+Surface", "totalEstimatedMatches": 1170000, "value": [{"name": "Microsoft Surface: Everything We Think We Know About New Hardware", "url": "http:\/\/www.bing.com\/cr?IG=E4A4A7E6A6004BF283761476B12975BB&CID=01DCC6193CE36E91187ACFB33DD26FEE&rd=1&h=zbWer8U7YMSWiryMbK-RVitP8SymF4ltVcEdXft8u3g&v=1&r=http%3a%2f%2ftechnofres.com%2f2016%2f10%2f10%2fmicrosoft-surface-everything-think-know-new-hardware%2f&p=DevEx,5021.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.23B0E23629356B1E8950F8A2AE526654&pid=News", "width": 696, "height": 392}}, "description": "#Microsoft #Surface – Microsoft Surface: Everything We Think We Know About New Hardware: It was on stage a year ago that Microsoft offered up fresh rivals to the iPhone, iPad, MacBook Air and MacBook devices that Apple uses to dominate the high-end ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/d3cf09a9-76dd-973e-2179-47f7f24c5e37", "name": "Microsoft Surface"}], "provider": [{"_type": "Organization", "name": "technofres.com"}], "datePublished": "2016-10-10T17:44:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6293,"0":6293}]}
Found Id: 6293
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "technofres.com_2016-10-10T17:44:00_ScienceAndTechnology", "title" : "Microsoft Surface: Everything We Think We Know About New Hardware"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "69"}}
{"data":[{"id":69,"0":69,"target_symbols_id":43,"1":43,"search_text":"Microsoft Surface","2":"Microsoft Surface","timestamp":"2016-10-04 23:20:35.910295-04","3":"2016-10-04 23:20:35.910295-04","active":1,"4":1}]}
Found Id: 69
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "43"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.8061764,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6294,"0":6294}]}
Found Id: 6294
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "technofres.com_2016-10-10T17:44:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0NDowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uMjNCMEUyMzYyOTM1NkIxRTg5NTBGOEEyQUU1MjY2NTQmcGlkPU5ld3MiLCJ3aWR0aCI6Njk2LCJoZWlnaHQiOjM5Mn19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoidGVjaG5vZnJlcy5jb20ifV0sIm5hbWUiOiJNaWNyb3NvZnQgU3VyZmFjZTogRXZlcnl0aGluZyBXZSBUaGluayBXZSBLbm93IEFib3V0IE5ldyBIYXJkd2FyZSIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9kM2NmMDlhOS03NmRkLTk3M2UtMjE3OS00N2Y3ZjI0YzVlMzciLCJuYW1lIjoiTWljcm9zb2Z0IFN1cmZhY2UifV0sImRlc2NyaXB0aW9uIjoiI01pY3Jvc29mdCAjU3VyZmFjZSBcdTIwMTMgTWljcm9zb2Z0IFN1cmZhY2U6IEV2ZXJ5dGhpbmcgV2UgVGhpbmsgV2UgS25vdyBBYm91dCBOZXcgSGFyZHdhcmU6IEl0IHdhcyBvbiBzdGFnZSBhIHllYXIgYWdvIHRoYXQgTWljcm9zb2Z0IG9mZmVyZWQgdXAgZnJlc2ggcml2YWxzIHRvIHRoZSBpUGhvbmUsIGlQYWQsIE1hY0Jvb2sgQWlyIGFuZCBNYWNCb29rIGRldmljZXMgdGhhdCBBcHBsZSB1c2VzIHRvIGRvbWluYXRlIHRoZSBoaWdoLWVuZCAuLi4iLCJjYXRlZ29yeSI6IlNjaWVuY2VBbmRUZWNobm9sb2d5IiwidXJsIjoiaHR0cDpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz1FNEE0QTdFNkE2MDA0QkYyODM3NjE0NzZCMTI5NzVCQiZDSUQ9MDFEQ0M2MTkzQ0UzNkU5MTE4N0FDRkIzM0REMjZGRUUmcmQ9MSZoPXpiV2VyOFU3WU1TV2lyeU1iSy1SVml0UDhTeW1GNGx0VmNFZFhmdDh1M2cmdj0xJnI9aHR0cCUzYSUyZiUyZnRlY2hub2ZyZXMuY29tJTJmMjAxNiUyZjEwJTJmMTAlMmZtaWNyb3NvZnQtc3VyZmFjZS1ldmVyeXRoaW5nLXRoaW5rLWtub3ctbmV3LWhhcmR3YXJlJTJmJnA9RGV2RXgsNTAyMS4xIn0=", "dataJsonVer" : "1.0", "targetSearchTextId" : "69", "sentimentScore" : "0.8061764", "active" : "1", "articleTitle" : "Microsoft Surface: Everything We Think We Know About New Hardware", "dataSourcesId" : "288", "publishDate" : "2016-10-10T17:44:00", "articleAbstract" : "#Microsoft #Surface – Microsoft Surface: Everything We Think We Know About New Hardware: It was on stage a year ago that Microsoft offered up fresh rivals to the iPhone, iPad, MacBook Air and MacBook devices that Apple uses to dominate the high-end ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2921,"0":2921}]}
Found Id: 2921
Error Count: 0
Found search text: Microsoft Office 365 with id: 70
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Microsoft+Office+365&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Microsoft+Office+365", "totalEstimatedMatches": 2460000, "value": [{"name": "Upcoming Office 365 features will advance accessibility", "url": "https:\/\/www.bing.com\/cr?IG=7641CD6B4DEE47E9B0F2197BCD012033&CID=2A2825F73EDF6DF9047E2C5D3FEE6CA2&rd=1&h=tzpbYccShvdOpZz5Xm3DKVb5CD3jm5QQJgV7H7Pj1-M&v=1&r=https%3a%2f%2fblogs.microsoft.com%2ffirehose%2f2016%2f10%2f10%2fupcoming-office-365-features-will-advance-accessibility%2f&p=DevEx,5019.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.C2423BC9C4E346F548443FCC5A434737&pid=News", "width": 640, "height": 426}}, "description": "At the Microsoft Ignite conference last month, Office 365 managers shared upcoming features to advance accessibility initiatives and create digitally inclusive environments. Those features will include accessibility checkers in more Office applications and ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/c7daa294-d7e1-0390-9f09-8f8c015391af", "name": "Microsoft Office 365"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/8d0eedb1-6f1f-f363-09a1-9adbce119dd5", "name": "Accessibility"}], "provider": [{"_type": "Organization", "name": "blogs.microsoft.com"}], "datePublished": "2016-10-10T17:49:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6295,"0":6295}]}
Found Id: 6295
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "blogs.microsoft.com_2016-10-10T17:49:00_ScienceAndTechnology", "title" : "Upcoming Office 365 features will advance accessibility"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "70"}}
{"data":[{"id":70,"0":70,"target_symbols_id":43,"1":43,"search_text":"Microsoft Office 365","2":"Microsoft Office 365","timestamp":"2016-10-04 23:20:35.984854-04","3":"2016-10-04 23:20:35.984854-04","active":1,"4":1}]}
Found Id: 70
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "43"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.9684017,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6296,"0":6296}]}
Found Id: 6296
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "blogs.microsoft.com_2016-10-10T17:49:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0OTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uQzI0MjNCQzlDNEUzNDZGNTQ4NDQzRkNDNUE0MzQ3MzcmcGlkPU5ld3MiLCJ3aWR0aCI6NjQwLCJoZWlnaHQiOjQyNn19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiYmxvZ3MubWljcm9zb2Z0LmNvbSJ9XSwibmFtZSI6IlVwY29taW5nIE9mZmljZSAzNjUgZmVhdHVyZXMgd2lsbCBhZHZhbmNlIGFjY2Vzc2liaWxpdHkiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvYzdkYWEyOTQtZDdlMS0wMzkwLTlmMDktOGY4YzAxNTM5MWFmIiwibmFtZSI6Ik1pY3Jvc29mdCBPZmZpY2UgMzY1In0seyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC84ZDBlZWRiMS02ZjFmLWYzNjMtMDlhMS05YWRiY2UxMTlkZDUiLCJuYW1lIjoiQWNjZXNzaWJpbGl0eSJ9XSwiZGVzY3JpcHRpb24iOiJBdCB0aGUgTWljcm9zb2Z0IElnbml0ZSBjb25mZXJlbmNlIGxhc3QgbW9udGgsIE9mZmljZSAzNjUgbWFuYWdlcnMgc2hhcmVkIHVwY29taW5nIGZlYXR1cmVzIHRvIGFkdmFuY2UgYWNjZXNzaWJpbGl0eSBpbml0aWF0aXZlcyBhbmQgY3JlYXRlIGRpZ2l0YWxseSBpbmNsdXNpdmUgZW52aXJvbm1lbnRzLiBUaG9zZSBmZWF0dXJlcyB3aWxsIGluY2x1ZGUgYWNjZXNzaWJpbGl0eSBjaGVja2VycyBpbiBtb3JlIE9mZmljZSBhcHBsaWNhdGlvbnMgYW5kIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwczpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz03NjQxQ0Q2QjRERUU0N0U5QjBGMjE5N0JDRDAxMjAzMyZDSUQ9MkEyODI1RjczRURGNkRGOTA0N0UyQzVEM0ZFRTZDQTImcmQ9MSZoPXR6cGJZY2NTaHZkT3BaejVYbTNES1ZiNUNEM2ptNVFRSmdWN0g3UGoxLU0mdj0xJnI9aHR0cHMlM2ElMmYlMmZibG9ncy5taWNyb3NvZnQuY29tJTJmZmlyZWhvc2UlMmYyMDE2JTJmMTAlMmYxMCUyZnVwY29taW5nLW9mZmljZS0zNjUtZmVhdHVyZXMtd2lsbC1hZHZhbmNlLWFjY2Vzc2liaWxpdHklMmYmcD1EZXZFeCw1MDE5LjEifQ==", "dataJsonVer" : "1.0", "targetSearchTextId" : "70", "sentimentScore" : "0.9684017", "active" : "1", "articleTitle" : "Upcoming Office 365 features will advance accessibility", "dataSourcesId" : "288", "publishDate" : "2016-10-10T17:49:00", "articleAbstract" : "At the Microsoft Ignite conference last month, Office 365 managers shared upcoming features to advance accessibility initiatives and create digitally inclusive environments. Those features will include accessibility checkers in more Office applications and ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2922,"0":2922}]}
Found Id: 2922
Error Count: 0
Found search text: Microsoft Azure with id: 71
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Microsoft+Azure&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Microsoft+Azure", "totalEstimatedMatches": 1320000, "value": [{"name": "Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers", "url": "http:\/\/www.bing.com\/cr?IG=0E121C183EBD4E23B5C0F42536853923&CID=0CDFD0DE009762772024D97401A66361&rd=1&h=sHn4IgcCrQDAOeRCHg47q0tbHDiUhusdmlSMpdhDbwU&v=1&r=http%3a%2f%2fwww.forbes.com%2fsites%2frogeraitken%2f2016%2f10%2f07%2fmicrosoft-azure-launches-easy-nxt-blockchain-nodes-for-developers%2f&p=DevEx,5022.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.E27FD6D3A965CF8F0839C13DF965B8D4&pid=News", "width": 700, "height": 465}}, "description": "Microsoft Azure, the cloud computing platform and infrastructure for building, deploying and managing applications through Microsoft’s global network of managed data centers, has officially brought the Nxt Blockchain to their platform. Now for the first ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/cf3abf7d-e379-2693-f765-6da6b9fa9149", "name": "Windows Azure"}], "provider": [{"_type": "Organization", "name": "Forbes"}], "datePublished": "2016-10-07T18:19:00", "category": "ScienceAndTechnology", "clusteredArticles": [{"name": "Microsoft Azure Includes Easy NXT Blockchain as a Service Offering", "url": "http:\/\/www.bing.com\/cr?IG=0E121C183EBD4E23B5C0F42536853923&CID=0CDFD0DE009762772024D97401A66361&rd=1&h=6Vjem16HTWE41-QfEoWi0yLpq43_Hdez2asr7tznkX4&v=1&r=http%3a%2f%2fwww.newsbtc.com%2f2016%2f10%2f09%2feasy-nxt-on-azure%2f&p=DevEx,5023.1", "description": "Microsoft’s Azure Blockchain-as-a-Service offering has added one more product, the Easy NXT. With Easy NXT, the platform now officially supports NXT Blockchain. The new product allows developers to easily deploy their own NXT nodes by following few ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/cf3abf7d-e379-2693-f765-6da6b9fa9149", "name": "Windows Azure"}], "provider": [{"_type": "Organization", "name": "newsBTC"}], "datePublished": "2016-10-09T15:44:00", "category": "ScienceAndTechnology"}]}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6297,"0":6297}]}
Found Id: 6297
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "Forbes_2016-10-07T18:19:00_ScienceAndTechnology", "title" : "Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "71"}}
{"data":[{"id":71,"0":71,"target_symbols_id":43,"1":43,"search_text":"Microsoft Azure","2":"Microsoft Azure","timestamp":"2016-10-04 23:20:36.060319-04","3":"2016-10-04 23:20:36.060319-04","active":1,"4":1}]}
Found Id: 71
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "43"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.8078103,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6298,"0":6298}]}
Found Id: 6298
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "Forbes_2016-10-07T18:19:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0wN1QxODoxOTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uRTI3RkQ2RDNBOTY1Q0Y4RjA4MzlDMTNERjk2NUI4RDQmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ2NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRm9yYmVzIn1dLCJjbHVzdGVyZWRBcnRpY2xlcyI6W3siZGF0ZVB1Ymxpc2hlZCI6IjIwMTYtMTAtMDlUMTU6NDQ6MDAiLCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoibmV3c0JUQyJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBJbmNsdWRlcyBFYXN5IE5YVCBCbG9ja2NoYWluIGFzIGEgU2VydmljZSBPZmZlcmluZyIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZjNhYmY3ZC1lMzc5LTI2OTMtZjc2NS02ZGE2YjlmYTkxNDkiLCJuYW1lIjoiV2luZG93cyBBenVyZSJ9XSwiZGVzY3JpcHRpb24iOiJNaWNyb3NvZnRcdTIwMTlzIEF6dXJlIEJsb2NrY2hhaW4tYXMtYS1TZXJ2aWNlIG9mZmVyaW5nIGhhcyBhZGRlZCBvbmUgbW9yZSBwcm9kdWN0LCB0aGUgRWFzeSBOWFQuIFdpdGggRWFzeSBOWFQsIHRoZSBwbGF0Zm9ybSBub3cgb2ZmaWNpYWxseSBzdXBwb3J0cyBOWFQgQmxvY2tjaGFpbi4gVGhlIG5ldyBwcm9kdWN0IGFsbG93cyBkZXZlbG9wZXJzIHRvIGVhc2lseSBkZXBsb3kgdGhlaXIgb3duIE5YVCBub2RlcyBieSBmb2xsb3dpbmcgZmV3IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9NlZqZW0xNkhUV0U0MS1RZkVvV2kweUxwcTQzX0hkZXoyYXNyN3R6bmtYNCZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3Lm5ld3NidGMuY29tJTJmMjAxNiUyZjEwJTJmMDklMmZlYXN5LW54dC1vbi1henVyZSUyZiZwPURldkV4LDUwMjMuMSJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBMYXVuY2hlcyAnRWFzeSBOWFQnIEJsb2NrY2hhaW4gTm9kZXMgRm9yIERldmVsb3BlcnMiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvY2YzYWJmN2QtZTM3OS0yNjkzLWY3NjUtNmRhNmI5ZmE5MTQ5IiwibmFtZSI6IldpbmRvd3MgQXp1cmUifV0sImRlc2NyaXB0aW9uIjoiTWljcm9zb2Z0IEF6dXJlLCB0aGUgY2xvdWQgY29tcHV0aW5nIHBsYXRmb3JtIGFuZCBpbmZyYXN0cnVjdHVyZSBmb3IgYnVpbGRpbmcsIGRlcGxveWluZyBhbmQgbWFuYWdpbmcgYXBwbGljYXRpb25zIHRocm91Z2ggTWljcm9zb2Z0XHUyMDE5cyBnbG9iYWwgbmV0d29yayBvZiBtYW5hZ2VkIGRhdGEgY2VudGVycywgaGFzIG9mZmljaWFsbHkgYnJvdWdodCB0aGUgTnh0IEJsb2NrY2hhaW4gdG8gdGhlaXIgcGxhdGZvcm0uIE5vdyBmb3IgdGhlIGZpcnN0IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9c0huNElnY0NyUURBT2VSQ0hnNDdxMHRiSERpVWh1c2RtbFNNcGRoRGJ3VSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LmZvcmJlcy5jb20lMmZzaXRlcyUyZnJvZ2VyYWl0a2VuJTJmMjAxNiUyZjEwJTJmMDclMmZtaWNyb3NvZnQtYXp1cmUtbGF1bmNoZXMtZWFzeS1ueHQtYmxvY2tjaGFpbi1ub2Rlcy1mb3ItZGV2ZWxvcGVycyUyZiZwPURldkV4LDUwMjIuMSJ9", "dataJsonVer" : "1.0", "targetSearchTextId" : "71", "sentimentScore" : "0.8078103", "active" : "1", "articleTitle" : "Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers", "dataSourcesId" : "288", "publishDate" : "2016-10-07T18:19:00", "articleAbstract" : "Microsoft Azure, the cloud computing platform and infrastructure for building, deploying and managing applications through Microsoft’s global network of managed data centers, has officially brought the Nxt Blockchain to their platform. Now for the first ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2923,"0":2923}]}
Found Id: 2923
Error Count: 0
Found symbol: FB with id: 44
Table: targetsearchtext: 
13) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "44"}}
{"data":[{"id":72,"0":72,"target_symbols_id":44,"1":44,"search_text":"Facebook Messenger","2":"Facebook Messenger","timestamp":"2016-10-04 23:20:36.173548-04","3":"2016-10-04 23:20:36.173548-04","active":1,"4":1},{"id":73,"0":73,"target_symbols_id":44,"1":44,"search_text":"Facebook Advertising","2":"Facebook Advertising","timestamp":"2016-10-04 23:20:36.243779-04","3":"2016-10-04 23:20:36.243779-04","active":1,"4":1},{"id":74,"0":74,"target_symbols_id":44,"1":44,"search_text":"Facebook Revenue","2":"Facebook Revenue","timestamp":"2016-10-04 23:20:36.322443-04","3":"2016-10-04 23:20:36.322443-04","active":1,"4":1}]}
Found Entry Count: 3
Found search text: Facebook Messenger with id: 72
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Facebook+Messenger&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Facebook+Messenger", "totalEstimatedMatches": 910000, "value": [{"name": "Eko Facebook Messenger Malware Targeting French Users via PM Scams", "url": "http:\/\/www.bing.com\/cr?IG=4402E455674248B594156F3996F6A957&CID=1CD048D544A567E30BB6417F4594667C&rd=1&h=yJN3Rl3TKqcxa7fGBCJpPRTULahu5ZxbkgzTXiDgRD4&v=1&r=http%3a%2f%2fwww.tripwire.com%2fstate-of-security%2flatest-security-news%2feko-facebook-messenger-malware-targeting-french-users-via-pm-scams%2f&p=DevEx,5023.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.B415EA3CB8A0842D322D59AD684E62C4&pid=News", "width": 512, "height": 251}}, "description": "A Facebook Messenger trojan known as “Eko” is targeting French users of the social networking site via private message (PM) scams. The malware takes the form of a common Facebook scam type: a fake video of the recipient captured by one of their social ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/86e334ae-c021-6867-b510-c8948525f0c6", "name": "Malware"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/0d2bf11c-b182-c8a6-f9a3-28c480429289", "name": "Facebook Messenger"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/c7bfe2de-4f82-e23c-ae42-8544b5b5c0ea", "name": "France"}], "provider": [{"_type": "Organization", "name": "tripwire.com"}], "datePublished": "2016-10-10T10:56:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6299,"0":6299}]}
Found Id: 6299
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "tripwire.com_2016-10-10T10:56:00_ScienceAndTechnology", "title" : "Eko Facebook Messenger Malware Targeting French Users via PM Scams"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "72"}}
{"data":[{"id":72,"0":72,"target_symbols_id":44,"1":44,"search_text":"Facebook Messenger","2":"Facebook Messenger","timestamp":"2016-10-04 23:20:36.173548-04","3":"2016-10-04 23:20:36.173548-04","active":1,"4":1}]}
Found Id: 72
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "44"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.7629157,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6300,"0":6300}]}
Found Id: 6300
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "tripwire.com_2016-10-10T10:56:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxMDo1NjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uQjQxNUVBM0NCOEEwODQyRDMyMkQ1OUFENjg0RTYyQzQmcGlkPU5ld3MiLCJ3aWR0aCI6NTEyLCJoZWlnaHQiOjI1MX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoidHJpcHdpcmUuY29tIn1dLCJuYW1lIjoiRWtvIEZhY2Vib29rIE1lc3NlbmdlciBNYWx3YXJlIFRhcmdldGluZyBGcmVuY2ggVXNlcnMgdmlhIFBNIFNjYW1zIiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzg2ZTMzNGFlLWMwMjEtNjg2Ny1iNTEwLWM4OTQ4NTI1ZjBjNiIsIm5hbWUiOiJNYWx3YXJlIn0seyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC8wZDJiZjExYy1iMTgyLWM4YTYtZjlhMy0yOGM0ODA0MjkyODkiLCJuYW1lIjoiRmFjZWJvb2sgTWVzc2VuZ2VyIn0seyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jN2JmZTJkZS00ZjgyLWUyM2MtYWU0Mi04NTQ0YjViNWMwZWEiLCJuYW1lIjoiRnJhbmNlIn1dLCJkZXNjcmlwdGlvbiI6IkEgRmFjZWJvb2sgTWVzc2VuZ2VyIHRyb2phbiBrbm93biBhcyBcdTIwMUNFa29cdTIwMUQgaXMgdGFyZ2V0aW5nIEZyZW5jaCB1c2VycyBvZiB0aGUgc29jaWFsIG5ldHdvcmtpbmcgc2l0ZSB2aWEgcHJpdmF0ZSBtZXNzYWdlIChQTSkgc2NhbXMuIFRoZSBtYWx3YXJlIHRha2VzIHRoZSBmb3JtIG9mIGEgY29tbW9uIEZhY2Vib29rIHNjYW0gdHlwZTogYSBmYWtlIHZpZGVvIG9mIHRoZSByZWNpcGllbnQgY2FwdHVyZWQgYnkgb25lIG9mIHRoZWlyIHNvY2lhbCAuLi4iLCJjYXRlZ29yeSI6IlNjaWVuY2VBbmRUZWNobm9sb2d5IiwidXJsIjoiaHR0cDpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz00NDAyRTQ1NTY3NDI0OEI1OTQxNTZGMzk5NkY2QTk1NyZDSUQ9MUNEMDQ4RDU0NEE1NjdFMzBCQjY0MTdGNDU5NDY2N0MmcmQ9MSZoPXlKTjNSbDNUS3FjeGE3ZkdCQ0pwUFJUVUxhaHU1Wnhia2d6VFhpRGdSRDQmdj0xJnI9aHR0cCUzYSUyZiUyZnd3dy50cmlwd2lyZS5jb20lMmZzdGF0ZS1vZi1zZWN1cml0eSUyZmxhdGVzdC1zZWN1cml0eS1uZXdzJTJmZWtvLWZhY2Vib29rLW1lc3Nlbmdlci1tYWx3YXJlLXRhcmdldGluZy1mcmVuY2gtdXNlcnMtdmlhLXBtLXNjYW1zJTJmJnA9RGV2RXgsNTAyMy4xIn0=", "dataJsonVer" : "1.0", "targetSearchTextId" : "72", "sentimentScore" : "0.7629157", "active" : "1", "articleTitle" : "Eko Facebook Messenger Malware Targeting French Users via PM Scams", "dataSourcesId" : "288", "publishDate" : "2016-10-10T10:56:00", "articleAbstract" : "A Facebook Messenger trojan known as “Eko” is targeting French users of the social networking site via private message (PM) scams. The malware takes the form of a common Facebook scam type: a fake video of the recipient captured by one of their social ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2924,"0":2924}]}
Found Id: 2924
Error Count: 0
Found search text: Facebook Advertising with id: 73
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Facebook+Advertising&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Facebook+Advertising", "totalEstimatedMatches": 1370000, "value": [{"name": "8 Authentic Ways to Align Your Facebook Ads With Your Brand Design", "url": "https:\/\/www.bing.com\/cr?IG=73287D099F3A4C299EA95765F07809A2&CID=3EFD6AA3AEEE68C002A36309AFDF694C&rd=1&h=Bozuv7CDP07ljCZYlk7vRYetr8o61aqjbLV3MdyfYfM&v=1&r=https%3a%2f%2fadespresso.com%2facademy%2fblog%2f8-authentic-ways-align-facebook-ads-brand-design%2f&p=DevEx,5021.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.20D03CC9A01C219D2F6F6B1F1893E6CB&pid=News", "width": 700, "height": 481}}, "description": "If someone saw your Facebook ad but your company’s name was hidden, could they associate it with your brand in 5 seconds? You’ve probably never thought about this question before. But it is super important. If people fail to associate your ads with ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/3313ae3a-fb26-e070-6882-eca15a5f25ea", "name": "Design"}], "provider": [{"_type": "Organization", "name": "adespresso.com"}], "datePublished": "2016-10-10T17:19:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6301,"0":6301}]}
Found Id: 6301
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "adespresso.com_2016-10-10T17:19:00_ScienceAndTechnology", "title" : "8 Authentic Ways to Align Your Facebook Ads With Your Brand Design"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "73"}}
{"data":[{"id":73,"0":73,"target_symbols_id":44,"1":44,"search_text":"Facebook Advertising","2":"Facebook Advertising","timestamp":"2016-10-04 23:20:36.243779-04","3":"2016-10-04 23:20:36.243779-04","active":1,"4":1}]}
Found Id: 73
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "44"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.9393062,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6302,"0":6302}]}
Found Id: 6302
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "adespresso.com_2016-10-10T17:19:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoxOTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uMjBEMDNDQzlBMDFDMjE5RDJGNkY2QjFGMTg5M0U2Q0ImcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ4MX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiYWRlc3ByZXNzby5jb20ifV0sIm5hbWUiOiI4IEF1dGhlbnRpYyBXYXlzIHRvIEFsaWduIFlvdXIgRmFjZWJvb2sgQWRzIFdpdGggWW91ciBCcmFuZCBEZXNpZ24iLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvMzMxM2FlM2EtZmIyNi1lMDcwLTY4ODItZWNhMTVhNWYyNWVhIiwibmFtZSI6IkRlc2lnbiJ9XSwiZGVzY3JpcHRpb24iOiJJZiBzb21lb25lIHNhdyB5b3VyIEZhY2Vib29rIGFkIGJ1dCB5b3VyIGNvbXBhbnlcdTIwMTlzIG5hbWUgd2FzIGhpZGRlbiwgY291bGQgdGhleSBhc3NvY2lhdGUgaXQgd2l0aCB5b3VyIGJyYW5kIGluIDUgc2Vjb25kcz8gWW91XHUyMDE5dmUgcHJvYmFibHkgbmV2ZXIgdGhvdWdodCBhYm91dCB0aGlzIHF1ZXN0aW9uIGJlZm9yZS4gQnV0IGl0IGlzIHN1cGVyIGltcG9ydGFudC4gSWYgcGVvcGxlIGZhaWwgdG8gYXNzb2NpYXRlIHlvdXIgYWRzIHdpdGggLi4uIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHBzOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTczMjg3RDA5OUYzQTRDMjk5RUE5NTc2NUYwNzgwOUEyJkNJRD0zRUZENkFBM0FFRUU2OEMwMDJBMzYzMDlBRkRGNjk0QyZyZD0xJmg9Qm96dXY3Q0RQMDdsakNaWWxrN3ZSWWV0cjhvNjFhcWpiTFYzTWR5ZllmTSZ2PTEmcj1odHRwcyUzYSUyZiUyZmFkZXNwcmVzc28uY29tJTJmYWNhZGVteSUyZmJsb2clMmY4LWF1dGhlbnRpYy13YXlzLWFsaWduLWZhY2Vib29rLWFkcy1icmFuZC1kZXNpZ24lMmYmcD1EZXZFeCw1MDIxLjEifQ==", "dataJsonVer" : "1.0", "targetSearchTextId" : "73", "sentimentScore" : "0.9393062", "active" : "1", "articleTitle" : "8 Authentic Ways to Align Your Facebook Ads With Your Brand Design", "dataSourcesId" : "288", "publishDate" : "2016-10-10T17:19:00", "articleAbstract" : "If someone saw your Facebook ad but your company’s name was hidden, could they associate it with your brand in 5 seconds? You’ve probably never thought about this question before. But it is super important. If people fail to associate your ads with ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2925,"0":2925}]}
Found Id: 2925
Error Count: 0
Found search text: Facebook Revenue with id: 74
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Facebook+Revenue&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Facebook+Revenue", "totalEstimatedMatches": 595000, "value": [{"name": "Facebook headed to the office with Workplace", "url": "http:\/\/www.bing.com\/cr?IG=1D0B723B16964B6C9952A031707CD081&CID=0C1D58B77B986693297F511D7AA96722&rd=1&h=FNzuPaSD7JhMzlmNvkvrZhLRW-WInKuwMJfdUbbo_Q8&v=1&r=http%3a%2f%2fwww.usatoday.com%2fstory%2ftech%2fnews%2f2016%2f10%2f10%2ffacebook-workplace%2f91754484%2f&p=DevEx,5023.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.D1B31746E60C836048A6970BB874C2D6&pid=News", "width": 534, "height": 401}}, "description": "On Monday the giant social network officially launched Workplace by Facebook, a commercial version of its popular social networking service in a direct challenge to enterprise software makers and a bid to collect subscription revenue from businesses.", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/994e5de7-0094-4bff-d009-f747d32f6eea", "name": "Workplace"}], "provider": [{"_type": "Organization", "name": "USA Today"}], "datePublished": "2016-10-10T17:01:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6303,"0":6303}]}
Found Id: 6303
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "USA Today_2016-10-10T17:01:00_ScienceAndTechnology", "title" : "Facebook headed to the office with Workplace"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "74"}}
{"data":[{"id":74,"0":74,"target_symbols_id":44,"1":44,"search_text":"Facebook Revenue","2":"Facebook Revenue","timestamp":"2016-10-04 23:20:36.322443-04","3":"2016-10-04 23:20:36.322443-04","active":1,"4":1}]}
Found Id: 74
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "44"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.9416556,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6304,"0":6304}]}
Found Id: 6304
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "USA Today_2016-10-10T17:01:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzowMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uRDFCMzE3NDZFNjBDODM2MDQ4QTY5NzBCQjg3NEMyRDYmcGlkPU5ld3MiLCJ3aWR0aCI6NTM0LCJoZWlnaHQiOjQwMX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVVNBIFRvZGF5In1dLCJuYW1lIjoiRmFjZWJvb2sgaGVhZGVkIHRvIHRoZSBvZmZpY2Ugd2l0aCBXb3JrcGxhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvOTk0ZTVkZTctMDA5NC00YmZmLWQwMDktZjc0N2QzMmY2ZWVhIiwibmFtZSI6IldvcmtwbGFjZSJ9XSwiZGVzY3JpcHRpb24iOiJPbiBNb25kYXkgdGhlIGdpYW50IHNvY2lhbCBuZXR3b3JrIG9mZmljaWFsbHkgbGF1bmNoZWQgV29ya3BsYWNlIGJ5IEZhY2Vib29rLCBhIGNvbW1lcmNpYWwgdmVyc2lvbiBvZiBpdHMgcG9wdWxhciBzb2NpYWwgbmV0d29ya2luZyBzZXJ2aWNlIGluIGEgZGlyZWN0IGNoYWxsZW5nZSB0byBlbnRlcnByaXNlIHNvZnR3YXJlIG1ha2VycyBhbmQgYSBiaWQgdG8gY29sbGVjdCBzdWJzY3JpcHRpb24gcmV2ZW51ZSBmcm9tIGJ1c2luZXNzZXMuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I/SUc9MUQwQjcyM0IxNjk2NEI2Qzk5NTJBMDMxNzA3Q0QwODEmQ0lEPTBDMUQ1OEI3N0I5ODY2OTMyOTdGNTExRDdBQTk2NzIyJnJkPTEmaD1GTnp1UGFTRDdKaE16bG1Odmt2clpoTFJXLVdJbkt1d01KZmRVYmJvX1E4JnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cudXNhdG9kYXkuY29tJTJmc3RvcnklMmZ0ZWNoJTJmbmV3cyUyZjIwMTYlMmYxMCUyZjEwJTJmZmFjZWJvb2std29ya3BsYWNlJTJmOTE3NTQ0ODQlMmYmcD1EZXZFeCw1MDIzLjEifQ==", "dataJsonVer" : "1.0", "targetSearchTextId" : "74", "sentimentScore" : "0.9416556", "active" : "1", "articleTitle" : "Facebook headed to the office with Workplace", "dataSourcesId" : "288", "publishDate" : "2016-10-10T17:01:00", "articleAbstract" : "On Monday the giant social network officially launched Workplace by Facebook, a commercial version of its popular social networking service in a direct challenge to enterprise software makers and a bid to collect subscription revenue from businesses.", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2926,"0":2926}]}
Found Id: 2926
Error Count: 0
Found symbol: AAPL with id: 45
Table: targetsearchtext: 
13) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "45"}}
{"data":[{"id":75,"0":75,"target_symbols_id":45,"1":45,"search_text":"iPhone 7","2":"iPhone 7","timestamp":"2016-10-04 23:20:36.427841-04","3":"2016-10-04 23:20:36.427841-04","active":1,"4":1},{"id":76,"0":76,"target_symbols_id":45,"1":45,"search_text":"iOS 10","2":"iOS 10","timestamp":"2016-10-04 23:20:36.50638-04","3":"2016-10-04 23:20:36.50638-04","active":1,"4":1},{"id":77,"0":77,"target_symbols_id":45,"1":45,"search_text":"Apple","2":"Apple","timestamp":"2016-10-04 23:20:36.577829-04","3":"2016-10-04 23:20:36.577829-04","active":1,"4":1}]}
Found Entry Count: 3
Found search text: iPhone 7 with id: 75
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=iPhone+7&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=iPhone+7", "totalEstimatedMatches": 1120000, "value": [{"name": "Olloclip's new lenses attach quickly to your iPhone 7", "url": "https:\/\/www.bing.com\/cr?IG=8B648A0156114439A5E56C9560BE5203&CID=3C835A4D9DE16785371953E79CD066DE&rd=1&h=Vj_ID770EkngD30s1qpHB3qfDFgi9H8Sq07g_3ZkwW0&v=1&r=https%3a%2f%2fwww.engadget.com%2f2016%2f10%2f10%2folloclip-iphone-7-lenses%2f&p=DevEx,5023.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.3321DC0E464C904B296C2503ABE5821F&pid=News", "width": 682, "height": 455}}, "description": "Now that there are new iPhones with revised cameras, many smartphone photographers are going to want new Olloclip lenses. Thankfully, they've arrived... and Olloclip didn't just tweak the connectors and call it a day. Its new Core, Active and Macro Pro ...", "provider": [{"_type": "Organization", "name": "Engadget"}], "datePublished": "2016-10-10T17:40:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6305,"0":6305}]}
Found Id: 6305
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "Engadget_2016-10-10T17:40:00_ScienceAndTechnology", "title" : "Olloclip's new lenses attach quickly to your iPhone 7"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "75"}}
{"data":[{"id":75,"0":75,"target_symbols_id":45,"1":45,"search_text":"iPhone 7","2":"iPhone 7","timestamp":"2016-10-04 23:20:36.427841-04","3":"2016-10-04 23:20:36.427841-04","active":1,"4":1}]}
Found Id: 75
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "45"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.6977513,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6306,"0":6306}]}
Found Id: 6306
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "Engadget_2016-10-10T17:40:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0MDowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uMzMyMURDMEU0NjRDOTA0QjI5NkMyNTAzQUJFNTgyMUYmcGlkPU5ld3MiLCJ3aWR0aCI6NjgyLCJoZWlnaHQiOjQ1NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRW5nYWRnZXQifV0sIm5hbWUiOiJPbGxvY2xpcCdzIG5ldyBsZW5zZXMgYXR0YWNoIHF1aWNrbHkgdG8geW91ciBpUGhvbmUgNyIsImRlc2NyaXB0aW9uIjoiTm93IHRoYXQgdGhlcmUgYXJlIG5ldyBpUGhvbmVzIHdpdGggcmV2aXNlZCBjYW1lcmFzLCBtYW55IHNtYXJ0cGhvbmUgcGhvdG9ncmFwaGVycyBhcmUgZ29pbmcgdG8gd2FudCBuZXcgT2xsb2NsaXAgbGVuc2VzLiBUaGFua2Z1bGx5LCB0aGV5J3ZlIGFycml2ZWQuLi4gYW5kIE9sbG9jbGlwIGRpZG4ndCBqdXN0IHR3ZWFrIHRoZSBjb25uZWN0b3JzIGFuZCBjYWxsIGl0IGEgZGF5LiBJdHMgbmV3IENvcmUsIEFjdGl2ZSBhbmQgTWFjcm8gUHJvIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwczpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz04QjY0OEEwMTU2MTE0NDM5QTVFNTZDOTU2MEJFNTIwMyZDSUQ9M0M4MzVBNEQ5REUxNjc4NTM3MTk1M0U3OUNEMDY2REUmcmQ9MSZoPVZqX0lENzcwRWtuZ0QzMHMxcXBIQjNxZkRGZ2k5SDhTcTA3Z18zWmt3VzAmdj0xJnI9aHR0cHMlM2ElMmYlMmZ3d3cuZW5nYWRnZXQuY29tJTJmMjAxNiUyZjEwJTJmMTAlMmZvbGxvY2xpcC1pcGhvbmUtNy1sZW5zZXMlMmYmcD1EZXZFeCw1MDIzLjEifQ==", "dataJsonVer" : "1.0", "targetSearchTextId" : "75", "sentimentScore" : "0.6977513", "active" : "1", "articleTitle" : "Olloclip's new lenses attach quickly to your iPhone 7", "dataSourcesId" : "288", "publishDate" : "2016-10-10T17:40:00", "articleAbstract" : "Now that there are new iPhones with revised cameras, many smartphone photographers are going to want new Olloclip lenses. Thankfully, they've arrived... and Olloclip didn't just tweak the connectors and call it a day. Its new Core, Active and Macro Pro ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2927,"0":2927}]}
Found Id: 2927
Error Count: 0
Found search text: iOS 10 with id: 76
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=iOS+10&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=iOS+10", "totalEstimatedMatches": 1740000, "value": [{"name": "People are adopting iOS 10 at a record rate", "url": "http:\/\/www.bing.com\/cr?IG=34520E6FA1F14708A6F0297DB63DDA96&CID=1E139A7C4CAB6BAE11DF93D64D9A6AB6&rd=1&h=jzG7xmEoisP58KO5JJoWx9__UwYrqe_NKDNf-UVQwHE&v=1&r=http%3a%2f%2fwww.businessinsider.com%2fapple-ios-10-adoption-rate-android-2016-10&p=DevEx,5022.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.4F4CF92C05E40AD685CE7D70F16C5BEB&pid=News", "width": 700, "height": 350}}, "description": "iOS 10 is now installed on roughly two-thirds of active iOS devices, according to data from tracking firms Mixpanel and Fiksu DSP. Mixpanel pegs 65.21% of iOS device users as having Apple’s latest software update, while Fiksu DSP has it at 66.7%.", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/cd479382-d340-5848-c99d-ed371b00b752", "name": "Android"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/16e46246-2257-643b-488c-f1572d8a9817", "name": "iOS"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/e27c5d96-fa70-a52e-3db3-ee99a47ed26e", "name": "Adoption"}], "provider": [{"_type": "Organization", "name": "The Business Insider"}], "datePublished": "2016-10-10T16:52:00", "category": "ScienceAndTechnology", "clusteredArticles": [{"name": "iOS 10 now has fastest adoption rate of any iOS update, installed on two thirds of devices", "url": "http:\/\/www.bing.com\/cr?IG=34520E6FA1F14708A6F0297DB63DDA96&CID=1E139A7C4CAB6BAE11DF93D64D9A6AB6&rd=1&h=cKtiFIcv4iumQmSnm13goxm_5OY8WtCTF__qpvOINpA&v=1&r=http%3a%2f%2fwww.todaysiphone.com%2f2016%2f10%2fios-10-fastest-adoption-rate-any-ios-update%2f&p=DevEx,5023.1", "description": "iOS 10 is now installed on a record breaking 66.7% of support devices, twenty-seven days after iOS 10 was released according to Fiksu. Mixpanel also says that iOS 10 is at 66% adoption as of Sunday. Nearly a month after release, iOS 10 has become the ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/16e46246-2257-643b-488c-f1572d8a9817", "name": "iOS"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/e27c5d96-fa70-a52e-3db3-ee99a47ed26e", "name": "Adoption"}], "provider": [{"_type": "Organization", "name": "todaysiphone.com"}], "datePublished": "2016-10-10T17:10:00", "category": "ScienceAndTechnology"}]}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6307,"0":6307}]}
Found Id: 6307
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "The Business Insider_2016-10-10T16:52:00_ScienceAndTechnology", "title" : "People are adopting iOS 10 at a record rate"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "76"}}
{"data":[{"id":76,"0":76,"target_symbols_id":45,"1":45,"search_text":"iOS 10","2":"iOS 10","timestamp":"2016-10-04 23:20:36.50638-04","3":"2016-10-04 23:20:36.50638-04","active":1,"4":1}]}
Found Id: 76
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "45"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.0661445,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6308,"0":6308}]}
Found Id: 6308
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "The Business Insider_2016-10-10T16:52:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNjo1MjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uNEY0Q0Y5MkMwNUU0MEFENjg1Q0U3RDcwRjE2QzVCRUImcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM1MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVGhlIEJ1c2luZXNzIEluc2lkZXIifV0sImNsdXN0ZXJlZEFydGljbGVzIjpbeyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoxMDowMCIsInByb3ZpZGVyIjpbeyJfdHlwZSI6Ik9yZ2FuaXphdGlvbiIsIm5hbWUiOiJ0b2RheXNpcGhvbmUuY29tIn1dLCJuYW1lIjoiaU9TIDEwIG5vdyBoYXMgZmFzdGVzdCBhZG9wdGlvbiByYXRlIG9mIGFueSBpT1MgdXBkYXRlLCBpbnN0YWxsZWQgb24gdHdvIHRoaXJkcyBvZiBkZXZpY2VzIiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzE2ZTQ2MjQ2LTIyNTctNjQzYi00ODhjLWYxNTcyZDhhOTgxNyIsIm5hbWUiOiJpT1MifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2UyN2M1ZDk2LWZhNzAtYTUyZS0zZGIzLWVlOTlhNDdlZDI2ZSIsIm5hbWUiOiJBZG9wdGlvbiJ9XSwiZGVzY3JpcHRpb24iOiJpT1MgMTAgaXMgbm93IGluc3RhbGxlZCBvbiBhIHJlY29yZCBicmVha2luZyA2Ni43JSBvZiBzdXBwb3J0IGRldmljZXMsIHR3ZW50eS1zZXZlbiBkYXlzIGFmdGVyIGlPUyAxMCB3YXMgcmVsZWFzZWQgYWNjb3JkaW5nIHRvIEZpa3N1LiBNaXhwYW5lbCBhbHNvIHNheXMgdGhhdCBpT1MgMTAgaXMgYXQgNjYlIGFkb3B0aW9uIGFzIG9mIFN1bmRheS4gTmVhcmx5IGEgbW9udGggYWZ0ZXIgcmVsZWFzZSwgaU9TIDEwIGhhcyBiZWNvbWUgdGhlIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTM0NTIwRTZGQTFGMTQ3MDhBNkYwMjk3REI2M0REQTk2JkNJRD0xRTEzOUE3QzRDQUI2QkFFMTFERjkzRDY0RDlBNkFCNiZyZD0xJmg9Y0t0aUZJY3Y0aXVtUW1Tbm0xM2dveG1fNU9ZOFd0Q1RGX19xcHZPSU5wQSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LnRvZGF5c2lwaG9uZS5jb20lMmYyMDE2JTJmMTAlMmZpb3MtMTAtZmFzdGVzdC1hZG9wdGlvbi1yYXRlLWFueS1pb3MtdXBkYXRlJTJmJnA9RGV2RXgsNTAyMy4xIn1dLCJuYW1lIjoiUGVvcGxlIGFyZSBhZG9wdGluZyBpT1MgMTAgYXQgYSByZWNvcmQgcmF0ZSIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZDQ3OTM4Mi1kMzQwLTU4NDgtYzk5ZC1lZDM3MWIwMGI3NTIiLCJuYW1lIjoiQW5kcm9pZCJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvMTZlNDYyNDYtMjI1Ny02NDNiLTQ4OGMtZjE1NzJkOGE5ODE3IiwibmFtZSI6ImlPUyJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvZTI3YzVkOTYtZmE3MC1hNTJlLTNkYjMtZWU5OWE0N2VkMjZlIiwibmFtZSI6IkFkb3B0aW9uIn1dLCJkZXNjcmlwdGlvbiI6ImlPUyAxMCBpcyBub3cgaW5zdGFsbGVkIG9uIHJvdWdobHkgdHdvLXRoaXJkcyBvZiBhY3RpdmUgaU9TIGRldmljZXMsIGFjY29yZGluZyB0byBkYXRhIGZyb20gdHJhY2tpbmcgZmlybXMgTWl4cGFuZWwgYW5kIEZpa3N1IERTUC4gTWl4cGFuZWwgcGVncyA2NS4yMSUgb2YgaU9TIGRldmljZSB1c2VycyBhcyBoYXZpbmcgQXBwbGVcdTIwMTlzIGxhdGVzdCBzb2Z0d2FyZSB1cGRhdGUsIHdoaWxlIEZpa3N1IERTUCBoYXMgaXQgYXQgNjYuNyUuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I/SUc9MzQ1MjBFNkZBMUYxNDcwOEE2RjAyOTdEQjYzRERBOTYmQ0lEPTFFMTM5QTdDNENBQjZCQUUxMURGOTNENjREOUE2QUI2JnJkPTEmaD1qekc3eG1Fb2lzUDU4S081SkpvV3g5X19Vd1lycWVfTktETmYtVVZRd0hFJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYnVzaW5lc3NpbnNpZGVyLmNvbSUyZmFwcGxlLWlvcy0xMC1hZG9wdGlvbi1yYXRlLWFuZHJvaWQtMjAxNi0xMCZwPURldkV4LDUwMjIuMSJ9", "dataJsonVer" : "1.0", "targetSearchTextId" : "76", "sentimentScore" : "0.0661445", "active" : "1", "articleTitle" : "People are adopting iOS 10 at a record rate", "dataSourcesId" : "288", "publishDate" : "2016-10-10T16:52:00", "articleAbstract" : "iOS 10 is now installed on roughly two-thirds of active iOS devices, according to data from tracking firms Mixpanel and Fiksu DSP. Mixpanel pegs 65.21% of iOS device users as having Apple’s latest software update, while Fiksu DSP has it at 66.7%.", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2928,"0":2928}]}
Found Id: 2928
Error Count: 0
Found search text: Apple with id: 77
Table: msnews: 
2) Add New News Articles
JsonData: https://api.cognitive.microsoft.com/bing/v5.0/news/search?q=Apple&count=1&offset=0&mkt=en-us&safeSearch=Moderate
{"_type": "News", "readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/news\/search?q=Apple", "totalEstimatedMatches": 2050000, "value": [{"name": "Apple and Samsung Take Design Dispute to Supreme Court", "url": "http:\/\/www.bing.com\/cr?IG=F3D9DAC271404B869C5BD9D7CD6FC842&CID=0A1BCF7F992B62FE3DC4C6D5981A636D&rd=1&h=4G1cpVMeD5Np7Op0ZQheoPROudKksCK1kztdAOJp4Jk&v=1&r=http%3a%2f%2fwww.bloomberg.com%2fpolitics%2farticles%2f2016-10-10%2fapple-fights-samsung-at-u-s-high-court-as-smartphone-wars-wane&p=DevEx,5025.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.E3A1D6CB41B23E8A863736326D9FBFE5&pid=News", "width": 700, "height": 466}}, "description": "The end of the smartphone wars is almost here. Six years after Apple Inc. filed its first lawsuit alleging unauthorized copying of the iPhone, the company will square off at the U.S. Supreme Court Tuesday against rival Samsung Electronics Co. They will ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/6fa57c29-e813-4a1d-7fba-3541ca4c1dc3", "name": "Apple Inc."}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/b8f26db0-d3b7-4fb5-fbb0-9ea469754434", "name": "Politics"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/c5ad466d-fd68-f389-4727-7f3b9daaebf6", "name": "Bloomberg L.P."}], "provider": [{"_type": "Organization", "name": "Bloomberg"}], "datePublished": "2016-10-10T10:06:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6309,"0":6309}]}
Found Id: 6309
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "Bloomberg_2016-10-10T10:06:00_ScienceAndTechnology", "title" : "Apple and Samsung Take Design Dispute to Supreme Court"}}
{"data":[]}
Found Entry Count: 0
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 0
Found Real Count: 0
CsaValue: []
Table: targetsearchtext: 
5) Get Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "targetSearchTextGet", "params" : {"id" : "77"}}
{"data":[{"id":77,"0":77,"target_symbols_id":45,"1":45,"search_text":"Apple","2":"Apple","timestamp":"2016-10-04 23:20:36.577829-04","3":"2016-10-04 23:20:36.577829-04","active":1,"4":1}]}
Found Id: 77
Table: textrefinement: 
12) Get By Target Symbols Id
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "textRefinementGetByTargetSymbolsId", "params" : {"targetSymbolsId" : "45"}}
{"data":[]}
Found Entry Count: 0
Table: mstxt: 
1) Get Text Sentiment Score
{ "data" : [{"documents":[{"score":0.1276454,"id":"test"}],"errors":[]}] }
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6310,"0":6310}]}
Found Id: 6310
Table: otherrpc: 
9) Get String Value from Variable
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "Bloomberg_2016-10-10T10:06:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxMDowNjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uRTNBMUQ2Q0I0MUIyM0U4QTg2MzczNjMyNkQ5RkJGRTUmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ2Nn19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiQmxvb21iZXJnIn1dLCJuYW1lIjoiQXBwbGUgYW5kIFNhbXN1bmcgVGFrZSBEZXNpZ24gRGlzcHV0ZSB0byBTdXByZW1lIENvdXJ0IiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzZmYTU3YzI5LWU4MTMtNGExZC03ZmJhLTM1NDFjYTRjMWRjMyIsIm5hbWUiOiJBcHBsZSBJbmMuIn0seyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9iOGYyNmRiMC1kM2I3LTRmYjUtZmJiMC05ZWE0Njk3NTQ0MzQiLCJuYW1lIjoiUG9saXRpY3MifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2M1YWQ0NjZkLWZkNjgtZjM4OS00NzI3LTdmM2I5ZGFhZWJmNiIsIm5hbWUiOiJCbG9vbWJlcmcgTC5QLiJ9XSwiZGVzY3JpcHRpb24iOiJUaGUgZW5kIG9mIHRoZSBzbWFydHBob25lIHdhcnMgaXMgYWxtb3N0IGhlcmUuIFNpeCB5ZWFycyBhZnRlciBBcHBsZSBJbmMuIGZpbGVkIGl0cyBmaXJzdCBsYXdzdWl0IGFsbGVnaW5nIHVuYXV0aG9yaXplZCBjb3B5aW5nIG9mIHRoZSBpUGhvbmUsIHRoZSBjb21wYW55IHdpbGwgc3F1YXJlIG9mZiBhdCB0aGUgVS5TLiBTdXByZW1lIENvdXJ0IFR1ZXNkYXkgYWdhaW5zdCByaXZhbCBTYW1zdW5nIEVsZWN0cm9uaWNzIENvLiBUaGV5IHdpbGwgLi4uIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I/SUc9RjNEOURBQzI3MTQwNEI4NjlDNUJEOUQ3Q0Q2RkM4NDImQ0lEPTBBMUJDRjdGOTkyQjYyRkUzREM0QzZENTk4MUE2MzZEJnJkPTEmaD00RzFjcFZNZUQ1TnA3T3AwWlFoZW9QUk91ZEtrc0NLMWt6dGRBT0pwNEprJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYmxvb21iZXJnLmNvbSUyZnBvbGl0aWNzJTJmYXJ0aWNsZXMlMmYyMDE2LTEwLTEwJTJmYXBwbGUtZmlnaHRzLXNhbXN1bmctYXQtdS1zLWhpZ2gtY291cnQtYXMtc21hcnRwaG9uZS13YXJzLXdhbmUmcD1EZXZFeCw1MDI1LjEifQ==", "dataJsonVer" : "1.0", "targetSearchTextId" : "77", "sentimentScore" : "0.1276454", "active" : "1", "articleTitle" : "Apple and Samsung Take Design Dispute to Supreme Court", "dataSourcesId" : "288", "publishDate" : "2016-10-10T10:06:00", "articleAbstract" : "The end of the smartphone wars is almost here. Six years after Apple Inc. filed its first lawsuit alleging unauthorized copying of the iPhone, the company will square off at the U.S. Supreme Court Tuesday against rival Samsung Electronics Co. They will ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2929,"0":2929}]}
Found Id: 2929
Error Count: 0

Execution Time: 104960ms
-----Usage Report-----
Total Commands Run: 96
Total JSON Commands Run: 1
Total Root JSON Commands Run: 1
Total Root JSON Commands Found: 1

Table: articles (Used 2 distinct commands)
	Command: 20
	Command: add

Table: datasourcesusage (Used 1 distinct commands)
	Command: 1

Table: intake (Used 1 distinct commands)
	Command: 1

Table: msnews (Used 1 distinct commands)
	Command: 2

Table: mstxt (Used 1 distinct commands)
	Command: 1

Table: otherrpc (Used 2 distinct commands)
	Command: 14
	Command: getvar

Table: targetsearchtext (Used 2 distinct commands)
	Command: 13
	Command: 5

Table: targetsymbols (Used 1 distinct commands)
	Command: 7

Table: textrefinement (Used 1 distinct commands)
	Command: 12