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: 
3) Daily News Intake Batch
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: 
3) Add New News Articles Batch
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 invites reporters to see what's next for Windows 10—and maybe Surface", "url": "http:\/\/www.bing.com\/cr?IG=BD1E8D29FDFB4B48BE72B36648947659&CID=02D0223A4281677600C12B9043B066B1&rd=1&h=07D3CS4hYXIsHdOUHTojiqxX9FZ-U2nTPBdtHbKnyf0&v=1&r=http%3a%2f%2fwww.pcworld.com%2farticle%2f3129288%2fwindows%2fmicrosoft-invites-reporters-to-see-whats-next-for-windows-10and-maybe-surface.html&p=DevEx,5021.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.700C68F8A0FC71F31ADD2E2F863ADFB7&pid=News", "width": 580, "height": 558}}, "description": "It’s official: Microsoft will hold an event in New York at the end of October where the company is expected to roll out a new Surface all-in-one PC. As we reported on Thursday, photos of a Surface-themed mouse and keyboard have already appeared in FCC ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/d3cf09a9-76dd-973e-2179-47f7f24c5e37", "name": "Microsoft Surface"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/16aeb6d9-9098-0a40-4970-8e46a4fcee12", "name": "Microsoft Windows"}], "provider": [{"_type": "Organization", "name": "PC World"}], "datePublished": "2016-10-10T10:31:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6320,"0":6320}]}
Found Id: 6320
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "PC World_2016-10-10T10:31:00_ScienceAndTechnology", "title" : "Microsoft invites reporters to see what's next for Windows 10—and maybe Surface"}}
{"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
New Batch Txt Snt: { "documents" : [{ "language": "en", "id": "PC World_2016-10-10T10:31:00_ScienceAndTechnology", "text": "Microsoft invites reporters to see what's next for Windows 10—and maybe Surface. It’s official: Microsoft will hold an event in New York at the end of October where the company is expected to roll out a new Surface all-in-one PC. As we reported on Thursday, photos of a Surface-themed mouse and keyboard have already appeared in FCC ..." }]}
Table: mstxt: 
2) Get Batch Text Sentiment Score
{ "data" : [{"documents":[{"score":0.1055072,"id":"PC World_2016-10-10T10:31:00_ScienceAndTechnology"}],"errors":[]}] }
Found Array Size: 1
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6321,"0":6321}]}
Found Id: 6321
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "PC World_2016-10-10T10:31:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxMDozMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uNzAwQzY4RjhBMEZDNzFGMzFBREQyRTJGODYzQURGQjcmcGlkPU5ld3MiLCJ3aWR0aCI6NTgwLCJoZWlnaHQiOjU1OH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiUEMgV29ybGQifV0sIm5hbWUiOiJNaWNyb3NvZnQgaW52aXRlcyByZXBvcnRlcnMgdG8gc2VlIHdoYXQncyBuZXh0IGZvciBXaW5kb3dzIDEwXHUyMDE0YW5kIG1heWJlIFN1cmZhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvZDNjZjA5YTktNzZkZC05NzNlLTIxNzktNDdmN2YyNGM1ZTM3IiwibmFtZSI6Ik1pY3Jvc29mdCBTdXJmYWNlIn0seyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC8xNmFlYjZkOS05MDk4LTBhNDAtNDk3MC04ZTQ2YTRmY2VlMTIiLCJuYW1lIjoiTWljcm9zb2Z0IFdpbmRvd3MifV0sImRlc2NyaXB0aW9uIjoiSXRcdTIwMTlzIG9mZmljaWFsOiBNaWNyb3NvZnQgd2lsbCBob2xkIGFuIGV2ZW50IGluIE5ldyBZb3JrIGF0IHRoZSBlbmQgb2YgT2N0b2JlciB3aGVyZSB0aGUgY29tcGFueSBpcyBleHBlY3RlZCB0byByb2xsIG91dCBhIG5ldyBTdXJmYWNlIGFsbC1pbi1vbmUgUEMuIEFzIHdlIHJlcG9ydGVkIG9uIFRodXJzZGF5LCBwaG90b3Mgb2YgYSBTdXJmYWNlLXRoZW1lZCBtb3VzZSBhbmQga2V5Ym9hcmQgaGF2ZSBhbHJlYWR5IGFwcGVhcmVkIGluIEZDQyAuLi4iLCJjYXRlZ29yeSI6IlNjaWVuY2VBbmRUZWNobm9sb2d5IiwidXJsIjoiaHR0cDpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz1CRDFFOEQyOUZERkI0QjQ4QkU3MkIzNjY0ODk0NzY1OSZDSUQ9MDJEMDIyM0E0MjgxNjc3NjAwQzEyQjkwNDNCMDY2QjEmcmQ9MSZoPTA3RDNDUzRoWVhJc0hkT1VIVG9qaXF4WDlGWi1VMm5UUEJkdEhiS255ZjAmdj0xJnI9aHR0cCUzYSUyZiUyZnd3dy5wY3dvcmxkLmNvbSUyZmFydGljbGUlMmYzMTI5Mjg4JTJmd2luZG93cyUyZm1pY3Jvc29mdC1pbnZpdGVzLXJlcG9ydGVycy10by1zZWUtd2hhdHMtbmV4dC1mb3Itd2luZG93cy0xMGFuZC1tYXliZS1zdXJmYWNlLmh0bWwmcD1EZXZFeCw1MDIxLjEifQ==", "dataJsonVer" : "1.0", "sentimentString" : "Microsoft invites reporters to see what's next for Windows 10—and maybe Surface. It’s official: Microsoft will hold an event in New York at the end of October where the company is expected to roll out a new Surface all-in-one PC. As we reported on Thursday, photos of a Surface-themed mouse and keyboard have already appeared in FCC ...", "targetSearchTextId" : "69", "sentimentScore" : "0.1055072", "active" : "1", "dataSourcesId" : "288", "articleTitle" : "Microsoft invites reporters to see what's next for Windows 10—and maybe Surface", "publishDate" : "2016-10-10T10:31:00", "articleAbstract" : "It’s official: Microsoft will hold an event in New York at the end of October where the company is expected to roll out a new Surface all-in-one PC. As we reported on Thursday, photos of a Surface-themed mouse and keyboard have already appeared in FCC ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2930,"0":2930}]}
Found Id: 2930
Error Count: 0
Found search text: Microsoft Office 365 with id: 70
Table: msnews: 
3) Add New News Articles Batch
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": "Analyze your organization’s Office 365 usage with these new Power BI tools", "url": "http:\/\/www.bing.com\/cr?IG=3F3E5E8C086B4858BD500AEC29B251DB&CID=16ABD64C15B267C331E0DFE6148366EF&rd=1&h=pjy1AVxzjhLaBxXKviih4soWWEDYEWgT_MptWp_S2xc&v=1&r=http%3a%2f%2fwinbeta.org%2fnews%2fanalyze-your-organizations-office-365-usage-with-these-new-power-bi-tools&p=DevEx,5019.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.995DA6773C1CEEC04DD781908EDD3C28&pid=News", "width": 700, "height": 390}}, "description": "Today, the Office 365 team announced the limited preview of a new integration with Microsoft Power BI. Using Power BI, Office 365 Admins will have better insight into how your group utilizes Office 365. There are four new Power BI dashboards available ...", "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\/7f08e163-e96c-f35d-4fd4-8a7036b60708", "name": "Usage"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/11a0df8c-1e51-c003-a80e-83c8d4f4bec2", "name": "Analyze"}], "provider": [{"_type": "Organization", "name": "Winbeta"}], "datePublished": "2016-10-10T17:25:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6322,"0":6322}]}
Found Id: 6322
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "Winbeta_2016-10-10T17:25:00_ScienceAndTechnology", "title" : "Analyze your organization’s Office 365 usage with these new Power BI tools"}}
{"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
New Batch Txt Snt: { "documents" : [{ "language": "en", "id": "Winbeta_2016-10-10T17:25:00_ScienceAndTechnology", "text": "Analyze your organization’s Office 365 usage with these new Power BI tools. Today, the Office 365 team announced the limited preview of a new integration with Microsoft Power BI. Using Power BI, Office 365 Admins will have better insight into how your group utilizes Office 365. There are four new Power BI dashboards available ..." }]}
Table: mstxt: 
2) Get Batch Text Sentiment Score
{ "data" : [{"documents":[{"score":0.5721355,"id":"Winbeta_2016-10-10T17:25:00_ScienceAndTechnology"}],"errors":[]}] }
Found Array Size: 1
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6323,"0":6323}]}
Found Id: 6323
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "Winbeta_2016-10-10T17:25:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoyNTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uOTk1REE2NzczQzFDRUVDMDRERDc4MTkwOEVERDNDMjgmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM5MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiV2luYmV0YSJ9XSwibmFtZSI6IkFuYWx5emUgeW91ciBvcmdhbml6YXRpb25cdTIwMTlzIE9mZmljZSAzNjUgdXNhZ2Ugd2l0aCB0aGVzZSBuZXcgUG93ZXIgQkkgdG9vbHMiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvYzdkYWEyOTQtZDdlMS0wMzkwLTlmMDktOGY4YzAxNTM5MWFmIiwibmFtZSI6Ik1pY3Jvc29mdCBPZmZpY2UgMzY1In0seyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC83ZjA4ZTE2My1lOTZjLWYzNWQtNGZkNC04YTcwMzZiNjA3MDgiLCJuYW1lIjoiVXNhZ2UifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzExYTBkZjhjLTFlNTEtYzAwMy1hODBlLTgzYzhkNGY0YmVjMiIsIm5hbWUiOiJBbmFseXplIn1dLCJkZXNjcmlwdGlvbiI6IlRvZGF5LCB0aGUgT2ZmaWNlIDM2NSB0ZWFtIGFubm91bmNlZCB0aGUgbGltaXRlZCBwcmV2aWV3IG9mIGEgbmV3IGludGVncmF0aW9uIHdpdGggTWljcm9zb2Z0IFBvd2VyIEJJLiBVc2luZyBQb3dlciBCSSwgT2ZmaWNlIDM2NSBBZG1pbnMgd2lsbCBoYXZlIGJldHRlciBpbnNpZ2h0IGludG8gaG93IHlvdXIgZ3JvdXAgdXRpbGl6ZXMgT2ZmaWNlIDM2NS4gVGhlcmUgYXJlIGZvdXIgbmV3IFBvd2VyIEJJIGRhc2hib2FyZHMgYXZhaWxhYmxlIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTNGM0U1RThDMDg2QjQ4NThCRDUwMEFFQzI5QjI1MURCJkNJRD0xNkFCRDY0QzE1QjI2N0MzMzFFMERGRTYxNDgzNjZFRiZyZD0xJmg9cGp5MUFWeHpqaExhQnhYS3ZpaWg0c29XV0VEWUVXZ1RfTXB0V3BfUzJ4YyZ2PTEmcj1odHRwJTNhJTJmJTJmd2luYmV0YS5vcmclMmZuZXdzJTJmYW5hbHl6ZS15b3VyLW9yZ2FuaXphdGlvbnMtb2ZmaWNlLTM2NS11c2FnZS13aXRoLXRoZXNlLW5ldy1wb3dlci1iaS10b29scyZwPURldkV4LDUwMTkuMSJ9", "dataJsonVer" : "1.0", "sentimentString" : "Analyze your organization’s Office 365 usage with these new Power BI tools. Today, the Office 365 team announced the limited preview of a new integration with Microsoft Power BI. Using Power BI, Office 365 Admins will have better insight into how your group utilizes Office 365. There are four new Power BI dashboards available ...", "targetSearchTextId" : "70", "sentimentScore" : "0.5721355", "active" : "1", "dataSourcesId" : "288", "articleTitle" : "Analyze your organization’s Office 365 usage with these new Power BI tools", "publishDate" : "2016-10-10T17:25:00", "articleAbstract" : "Today, the Office 365 team announced the limited preview of a new integration with Microsoft Power BI. Using Power BI, Office 365 Admins will have better insight into how your group utilizes Office 365. There are four new Power BI dashboards available ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2931,"0":2931}]}
Found Id: 2931
Error Count: 0
Found search text: Microsoft Azure with id: 71
Table: msnews: 
3) Add New News Articles Batch
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=6E5D33A6CD5B4C22B48167A8A9DEC5F9&CID=3188225FB083666F16242BF5B1B26794&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=6E5D33A6CD5B4C22B48167A8A9DEC5F9&CID=3188225FB083666F16242BF5B1B26794&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":6324,"0":6324}]}
Found Id: 6324
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":[{"id":2923,"0":2923,"timestamp":"2016-10-10 13:57:24.462309-04","1":"2016-10-10 13:57:24.462309-04","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0wN1QxODoxOTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRTI3RkQ2RDNBOTY1Q0Y4RjA4MzlDMTNERjk2NUI4RDQmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ2NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRm9yYmVzIn1dLCJjbHVzdGVyZWRBcnRpY2xlcyI6W3siZGF0ZVB1Ymxpc2hlZCI6IjIwMTYtMTAtMDlUMTU6NDQ6MDAiLCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoibmV3c0JUQyJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBJbmNsdWRlcyBFYXN5IE5YVCBCbG9ja2NoYWluIGFzIGEgU2VydmljZSBPZmZlcmluZyIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZjNhYmY3ZC1lMzc5LTI2OTMtZjc2NS02ZGE2YjlmYTkxNDkiLCJuYW1lIjoiV2luZG93cyBBenVyZSJ9XSwiZGVzY3JpcHRpb24iOiJNaWNyb3NvZnRcdTIwMTlzIEF6dXJlIEJsb2NrY2hhaW4tYXMtYS1TZXJ2aWNlIG9mZmVyaW5nIGhhcyBhZGRlZCBvbmUgbW9yZSBwcm9kdWN0LCB0aGUgRWFzeSBOWFQuIFdpdGggRWFzeSBOWFQsIHRoZSBwbGF0Zm9ybSBub3cgb2ZmaWNpYWxseSBzdXBwb3J0cyBOWFQgQmxvY2tjaGFpbi4gVGhlIG5ldyBwcm9kdWN0IGFsbG93cyBkZXZlbG9wZXJzIHRvIGVhc2lseSBkZXBsb3kgdGhlaXIgb3duIE5YVCBub2RlcyBieSBmb2xsb3dpbmcgZmV3IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9NlZqZW0xNkhUV0U0MS1RZkVvV2kweUxwcTQzX0hkZXoyYXNyN3R6bmtYNCZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3Lm5ld3NidGMuY29tJTJmMjAxNiUyZjEwJTJmMDklMmZlYXN5LW54dC1vbi1henVyZSUyZiZwPURldkV4LDUwMjMuMSJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBMYXVuY2hlcyAnRWFzeSBOWFQnIEJsb2NrY2hhaW4gTm9kZXMgRm9yIERldmVsb3BlcnMiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvY2YzYWJmN2QtZTM3OS0yNjkzLWY3NjUtNmRhNmI5ZmE5MTQ5IiwibmFtZSI6IldpbmRvd3MgQXp1cmUifV0sImRlc2NyaXB0aW9uIjoiTWljcm9zb2Z0IEF6dXJlLCB0aGUgY2xvdWQgY29tcHV0aW5nIHBsYXRmb3JtIGFuZCBpbmZyYXN0cnVjdHVyZSBmb3IgYnVpbGRpbmcsIGRlcGxveWluZyBhbmQgbWFuYWdpbmcgYXBwbGljYXRpb25zIHRocm91Z2ggTWljcm9zb2Z0XHUyMDE5cyBnbG9iYWwgbmV0d29yayBvZiBtYW5hZ2VkIGRhdGEgY2VudGVycywgaGFzIG9mZmljaWFsbHkgYnJvdWdodCB0aGUgTnh0IEJsb2NrY2hhaW4gdG8gdGhlaXIgcGxhdGZvcm0uIE5vdyBmb3IgdGhlIGZpcnN0IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9c0huNElnY0NyUURBT2VSQ0hnNDdxMHRiSERpVWh1c2RtbFNNcGRoRGJ3VSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LmZvcmJlcy5jb20lMmZzaXRlcyUyZnJvZ2VyYWl0a2VuJTJmMjAxNiUyZjEwJTJmMDclMmZtaWNyb3NvZnQtYXp1cmUtbGF1bmNoZXMtZWFzeS1ueHQtYmxvY2tjaGFpbi1ub2Rlcy1mb3ItZGV2ZWxvcGVycyUyZiZwPURldkV4LDUwMjIuMSJ9","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0wN1QxODoxOTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRTI3RkQ2RDNBOTY1Q0Y4RjA4MzlDMTNERjk2NUI4RDQmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ2NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRm9yYmVzIn1dLCJjbHVzdGVyZWRBcnRpY2xlcyI6W3siZGF0ZVB1Ymxpc2hlZCI6IjIwMTYtMTAtMDlUMTU6NDQ6MDAiLCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoibmV3c0JUQyJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBJbmNsdWRlcyBFYXN5IE5YVCBCbG9ja2NoYWluIGFzIGEgU2VydmljZSBPZmZlcmluZyIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZjNhYmY3ZC1lMzc5LTI2OTMtZjc2NS02ZGE2YjlmYTkxNDkiLCJuYW1lIjoiV2luZG93cyBBenVyZSJ9XSwiZGVzY3JpcHRpb24iOiJNaWNyb3NvZnRcdTIwMTlzIEF6dXJlIEJsb2NrY2hhaW4tYXMtYS1TZXJ2aWNlIG9mZmVyaW5nIGhhcyBhZGRlZCBvbmUgbW9yZSBwcm9kdWN0LCB0aGUgRWFzeSBOWFQuIFdpdGggRWFzeSBOWFQsIHRoZSBwbGF0Zm9ybSBub3cgb2ZmaWNpYWxseSBzdXBwb3J0cyBOWFQgQmxvY2tjaGFpbi4gVGhlIG5ldyBwcm9kdWN0IGFsbG93cyBkZXZlbG9wZXJzIHRvIGVhc2lseSBkZXBsb3kgdGhlaXIgb3duIE5YVCBub2RlcyBieSBmb2xsb3dpbmcgZmV3IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9NlZqZW0xNkhUV0U0MS1RZkVvV2kweUxwcTQzX0hkZXoyYXNyN3R6bmtYNCZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3Lm5ld3NidGMuY29tJTJmMjAxNiUyZjEwJTJmMDklMmZlYXN5LW54dC1vbi1henVyZSUyZiZwPURldkV4LDUwMjMuMSJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBMYXVuY2hlcyAnRWFzeSBOWFQnIEJsb2NrY2hhaW4gTm9kZXMgRm9yIERldmVsb3BlcnMiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvY2YzYWJmN2QtZTM3OS0yNjkzLWY3NjUtNmRhNmI5ZmE5MTQ5IiwibmFtZSI6IldpbmRvd3MgQXp1cmUifV0sImRlc2NyaXB0aW9uIjoiTWljcm9zb2Z0IEF6dXJlLCB0aGUgY2xvdWQgY29tcHV0aW5nIHBsYXRmb3JtIGFuZCBpbmZyYXN0cnVjdHVyZSBmb3IgYnVpbGRpbmcsIGRlcGxveWluZyBhbmQgbWFuYWdpbmcgYXBwbGljYXRpb25zIHRocm91Z2ggTWljcm9zb2Z0XHUyMDE5cyBnbG9iYWwgbmV0d29yayBvZiBtYW5hZ2VkIGRhdGEgY2VudGVycywgaGFzIG9mZmljaWFsbHkgYnJvdWdodCB0aGUgTnh0IEJsb2NrY2hhaW4gdG8gdGhlaXIgcGxhdGZvcm0uIE5vdyBmb3IgdGhlIGZpcnN0IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9c0huNElnY0NyUURBT2VSQ0hnNDdxMHRiSERpVWh1c2RtbFNNcGRoRGJ3VSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LmZvcmJlcy5jb20lMmZzaXRlcyUyZnJvZ2VyYWl0a2VuJTJmMjAxNiUyZjEwJTJmMDclMmZtaWNyb3NvZnQtYXp1cmUtbGF1bmNoZXMtZWFzeS1ueHQtYmxvY2tjaGFpbi1ub2Rlcy1mb3ItZGV2ZWxvcGVycyUyZiZwPURldkV4LDUwMjIuMSJ9","data_json_version":"1.0","3":"1.0","data_sources_id":288,"4":288,"sentiment_score":"0.8078103","5":"0.8078103","sentiment_score_version":"1.0","6":"1.0","publish_date":"2016-10-07","7":"2016-10-07","article_title":"Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers","8":"Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers","article_abstract":"Microsoft Azure, the cloud computing platform and infrastructure for building, deploying and managing applications through Microsoft\u2019s global network of managed data centers, has officially brought the Nxt Blockchain to their platform. Now for the first ...","9":"Microsoft Azure, the cloud computing platform and infrastructure for building, deploying and managing applications through Microsoft\u2019s global network of managed data centers, has officially brought the Nxt Blockchain to their platform. Now for the first ...","article_reference_id":"Forbes_2016-10-07T18:19:00_ScienceAndTechnology","10":"Forbes_2016-10-07T18:19:00_ScienceAndTechnology","active":1,"11":1,"target_search_text_id":71,"12":71}]}
Found Entry Count: 1
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 1
Found Real Count: 1
CsaValue: [{"article_abstract":"Microsoft Azure, the cloud computing platform and infrastructure for building, deploying and managing applications through Microsoft\u2019s global network of managed data centers, has officially brought the Nxt Blockchain to their platform. Now for the first ...","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0wN1QxODoxOTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRTI3RkQ2RDNBOTY1Q0Y4RjA4MzlDMTNERjk2NUI4RDQmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ2NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRm9yYmVzIn1dLCJjbHVzdGVyZWRBcnRpY2xlcyI6W3siZGF0ZVB1Ymxpc2hlZCI6IjIwMTYtMTAtMDlUMTU6NDQ6MDAiLCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoibmV3c0JUQyJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBJbmNsdWRlcyBFYXN5IE5YVCBCbG9ja2NoYWluIGFzIGEgU2VydmljZSBPZmZlcmluZyIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZjNhYmY3ZC1lMzc5LTI2OTMtZjc2NS02ZGE2YjlmYTkxNDkiLCJuYW1lIjoiV2luZG93cyBBenVyZSJ9XSwiZGVzY3JpcHRpb24iOiJNaWNyb3NvZnRcdTIwMTlzIEF6dXJlIEJsb2NrY2hhaW4tYXMtYS1TZXJ2aWNlIG9mZmVyaW5nIGhhcyBhZGRlZCBvbmUgbW9yZSBwcm9kdWN0LCB0aGUgRWFzeSBOWFQuIFdpdGggRWFzeSBOWFQsIHRoZSBwbGF0Zm9ybSBub3cgb2ZmaWNpYWxseSBzdXBwb3J0cyBOWFQgQmxvY2tjaGFpbi4gVGhlIG5ldyBwcm9kdWN0IGFsbG93cyBkZXZlbG9wZXJzIHRvIGVhc2lseSBkZXBsb3kgdGhlaXIgb3duIE5YVCBub2RlcyBieSBmb2xsb3dpbmcgZmV3IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9NlZqZW0xNkhUV0U0MS1RZkVvV2kweUxwcTQzX0hkZXoyYXNyN3R6bmtYNCZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3Lm5ld3NidGMuY29tJTJmMjAxNiUyZjEwJTJmMDklMmZlYXN5LW54dC1vbi1henVyZSUyZiZwPURldkV4LDUwMjMuMSJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBMYXVuY2hlcyAnRWFzeSBOWFQnIEJsb2NrY2hhaW4gTm9kZXMgRm9yIERldmVsb3BlcnMiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvY2YzYWJmN2QtZTM3OS0yNjkzLWY3NjUtNmRhNmI5ZmE5MTQ5IiwibmFtZSI6IldpbmRvd3MgQXp1cmUifV0sImRlc2NyaXB0aW9uIjoiTWljcm9zb2Z0IEF6dXJlLCB0aGUgY2xvdWQgY29tcHV0aW5nIHBsYXRmb3JtIGFuZCBpbmZyYXN0cnVjdHVyZSBmb3IgYnVpbGRpbmcsIGRlcGxveWluZyBhbmQgbWFuYWdpbmcgYXBwbGljYXRpb25zIHRocm91Z2ggTWljcm9zb2Z0XHUyMDE5cyBnbG9iYWwgbmV0d29yayBvZiBtYW5hZ2VkIGRhdGEgY2VudGVycywgaGFzIG9mZmljaWFsbHkgYnJvdWdodCB0aGUgTnh0IEJsb2NrY2hhaW4gdG8gdGhlaXIgcGxhdGZvcm0uIE5vdyBmb3IgdGhlIGZpcnN0IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9c0huNElnY0NyUURBT2VSQ0hnNDdxMHRiSERpVWh1c2RtbFNNcGRoRGJ3VSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LmZvcmJlcy5jb20lMmZzaXRlcyUyZnJvZ2VyYWl0a2VuJTJmMjAxNiUyZjEwJTJmMDclMmZtaWNyb3NvZnQtYXp1cmUtbGF1bmNoZXMtZWFzeS1ueHQtYmxvY2tjaGFpbi1ub2Rlcy1mb3ItZGV2ZWxvcGVycyUyZiZwPURldkV4LDUwMjIuMSJ9","id":2923,"timestamp":"2016-10-10 13:57:24.462309-04","10":"Forbes_2016-10-07T18:19:00_ScienceAndTechnology","11":1,"sentiment_score":"0.8078103","12":71,"article_reference_id":"Forbes_2016-10-07T18:19:00_ScienceAndTechnology","active":1,"data_sources_id":288,"sentiment_score_version":"1.0","0":2923,"1":"2016-10-10 13:57:24.462309-04","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0wN1QxODoxOTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRTI3RkQ2RDNBOTY1Q0Y4RjA4MzlDMTNERjk2NUI4RDQmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjQ2NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRm9yYmVzIn1dLCJjbHVzdGVyZWRBcnRpY2xlcyI6W3siZGF0ZVB1Ymxpc2hlZCI6IjIwMTYtMTAtMDlUMTU6NDQ6MDAiLCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoibmV3c0JUQyJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBJbmNsdWRlcyBFYXN5IE5YVCBCbG9ja2NoYWluIGFzIGEgU2VydmljZSBPZmZlcmluZyIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZjNhYmY3ZC1lMzc5LTI2OTMtZjc2NS02ZGE2YjlmYTkxNDkiLCJuYW1lIjoiV2luZG93cyBBenVyZSJ9XSwiZGVzY3JpcHRpb24iOiJNaWNyb3NvZnRcdTIwMTlzIEF6dXJlIEJsb2NrY2hhaW4tYXMtYS1TZXJ2aWNlIG9mZmVyaW5nIGhhcyBhZGRlZCBvbmUgbW9yZSBwcm9kdWN0LCB0aGUgRWFzeSBOWFQuIFdpdGggRWFzeSBOWFQsIHRoZSBwbGF0Zm9ybSBub3cgb2ZmaWNpYWxseSBzdXBwb3J0cyBOWFQgQmxvY2tjaGFpbi4gVGhlIG5ldyBwcm9kdWN0IGFsbG93cyBkZXZlbG9wZXJzIHRvIGVhc2lseSBkZXBsb3kgdGhlaXIgb3duIE5YVCBub2RlcyBieSBmb2xsb3dpbmcgZmV3IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9NlZqZW0xNkhUV0U0MS1RZkVvV2kweUxwcTQzX0hkZXoyYXNyN3R6bmtYNCZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3Lm5ld3NidGMuY29tJTJmMjAxNiUyZjEwJTJmMDklMmZlYXN5LW54dC1vbi1henVyZSUyZiZwPURldkV4LDUwMjMuMSJ9XSwibmFtZSI6Ik1pY3Jvc29mdCBBenVyZSBMYXVuY2hlcyAnRWFzeSBOWFQnIEJsb2NrY2hhaW4gTm9kZXMgRm9yIERldmVsb3BlcnMiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvY2YzYWJmN2QtZTM3OS0yNjkzLWY3NjUtNmRhNmI5ZmE5MTQ5IiwibmFtZSI6IldpbmRvd3MgQXp1cmUifV0sImRlc2NyaXB0aW9uIjoiTWljcm9zb2Z0IEF6dXJlLCB0aGUgY2xvdWQgY29tcHV0aW5nIHBsYXRmb3JtIGFuZCBpbmZyYXN0cnVjdHVyZSBmb3IgYnVpbGRpbmcsIGRlcGxveWluZyBhbmQgbWFuYWdpbmcgYXBwbGljYXRpb25zIHRocm91Z2ggTWljcm9zb2Z0XHUyMDE5cyBnbG9iYWwgbmV0d29yayBvZiBtYW5hZ2VkIGRhdGEgY2VudGVycywgaGFzIG9mZmljaWFsbHkgYnJvdWdodCB0aGUgTnh0IEJsb2NrY2hhaW4gdG8gdGhlaXIgcGxhdGZvcm0uIE5vdyBmb3IgdGhlIGZpcnN0IC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTBFMTIxQzE4M0VCRDRFMjNCNUMwRjQyNTM2ODUzOTIzJkNJRD0wQ0RGRDBERTAwOTc2Mjc3MjAyNEQ5NzQwMUE2NjM2MSZyZD0xJmg9c0huNElnY0NyUURBT2VSQ0hnNDdxMHRiSERpVWh1c2RtbFNNcGRoRGJ3VSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LmZvcmJlcy5jb20lMmZzaXRlcyUyZnJvZ2VyYWl0a2VuJTJmMjAxNiUyZjEwJTJmMDclMmZtaWNyb3NvZnQtYXp1cmUtbGF1bmNoZXMtZWFzeS1ueHQtYmxvY2tjaGFpbi1ub2Rlcy1mb3ItZGV2ZWxvcGVycyUyZiZwPURldkV4LDUwMjIuMSJ9","data_json_version":"1.0","article_title":"Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers","3":"1.0","target_search_text_id":71,"4":288,"5":"0.8078103","6":"1.0","7":"2016-10-07","8":"Microsoft Azure Launches 'Easy NXT' Blockchain Nodes For Developers","9":"Microsoft Azure, the cloud computing platform and infrastructure for building, deploying and managing applications through Microsoft\u2019s global network of managed data centers, has officially brought the Nxt Blockchain to their platform. Now for the first ...","publish_date":"2016-10-07"}]
No text sentiment cache found to process for this search string.
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: 
3) Add New News Articles Batch
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": 913000, "value": [{"name": "Facebook Messenger to be one of the most Downloaded App", "url": "http:\/\/www.bing.com\/cr?IG=63430DDA100049309587778EB71648CC&CID=23EBF7A901936DE617D9FE0300A26C07&rd=1&h=Kl31GvGwASsH_2SXIJgH1zRT3hZKrERSLXPDMwV2gGc&v=1&r=http%3a%2f%2fwww.newsmaritime.com%2f2016%2ffacebook-messenger-one-downloaded-app%2f&p=DevEx,5023.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.3DD646B72FC5694C4A6B5D26C6D5756F&pid=News", "width": 700, "height": 382}}, "description": "Facebook Messenger released five years ago in 2011. Facebook Messenger is an instant messaging service and is one of the best App which provides you text and voice communication. Messenger gets 100 Billion downloads on Google Play and is one of the fastest ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/0d2bf11c-b182-c8a6-f9a3-28c480429289", "name": "Facebook Messenger"}], "provider": [{"_type": "Organization", "name": "newsmaritime"}], "datePublished": "2016-10-10T18:02:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6325,"0":6325}]}
Found Id: 6325
Table: articles: 
20) Get By Title and Article Reference Id [title, articleReferenceId]
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesGetByTitleAndArticleReferenceId", "params" : {"articleReferenceId" : "newsmaritime_2016-10-10T18:02:00_ScienceAndTechnology", "title" : "Facebook Messenger to be one of the most Downloaded App"}}
{"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
New Batch Txt Snt: { "documents" : [{ "language": "en", "id": "newsmaritime_2016-10-10T18:02:00_ScienceAndTechnology", "text": "Facebook Messenger to be one of the most Downloaded App. Facebook Messenger released five years ago in 2011. Facebook Messenger is an instant messaging service and is one of the best App which provides you text and voice communication. Messenger gets 100 Billion downloads on Google Play and is one of the fastest ..." }]}
Table: mstxt: 
2) Get Batch Text Sentiment Score
{ "data" : [{"documents":[{"score":0.8907743,"id":"newsmaritime_2016-10-10T18:02:00_ScienceAndTechnology"}],"errors":[]}] }
Found Array Size: 1
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6326,"0":6326}]}
Found Id: 6326
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "newsmaritime_2016-10-10T18:02:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxODowMjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uM0RENjQ2QjcyRkM1Njk0QzRBNkI1RDI2QzZENTc1NkYmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM4Mn19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoibmV3c21hcml0aW1lIn1dLCJuYW1lIjoiRmFjZWJvb2sgTWVzc2VuZ2VyIHRvIGJlIG9uZSBvZiB0aGUgbW9zdCBEb3dubG9hZGVkIEFwcCIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC8wZDJiZjExYy1iMTgyLWM4YTYtZjlhMy0yOGM0ODA0MjkyODkiLCJuYW1lIjoiRmFjZWJvb2sgTWVzc2VuZ2VyIn1dLCJkZXNjcmlwdGlvbiI6IkZhY2Vib29rIE1lc3NlbmdlciByZWxlYXNlZCBmaXZlIHllYXJzIGFnbyBpbiAyMDExLiBGYWNlYm9vayBNZXNzZW5nZXIgaXMgYW4gaW5zdGFudCBtZXNzYWdpbmcgc2VydmljZSBhbmQgaXMgb25lIG9mIHRoZSBiZXN0IEFwcCB3aGljaCBwcm92aWRlcyB5b3UgdGV4dCBhbmQgdm9pY2UgY29tbXVuaWNhdGlvbi4gTWVzc2VuZ2VyIGdldHMgMTAwIEJpbGxpb24gZG93bmxvYWRzIG9uIEdvb2dsZSBQbGF5IGFuZCBpcyBvbmUgb2YgdGhlIGZhc3Rlc3QgLi4uIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I/SUc9NjM0MzBEREExMDAwNDkzMDk1ODc3NzhFQjcxNjQ4Q0MmQ0lEPTIzRUJGN0E5MDE5MzZERTYxN0Q5RkUwMzAwQTI2QzA3JnJkPTEmaD1LbDMxR3ZHd0FTc0hfMlNYSUpnSDF6UlQzaFpLckVSU0xYUERNd1YyZ0djJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cubmV3c21hcml0aW1lLmNvbSUyZjIwMTYlMmZmYWNlYm9vay1tZXNzZW5nZXItb25lLWRvd25sb2FkZWQtYXBwJTJmJnA9RGV2RXgsNTAyMy4xIn0=", "dataJsonVer" : "1.0", "sentimentString" : "Facebook Messenger to be one of the most Downloaded App. Facebook Messenger released five years ago in 2011. Facebook Messenger is an instant messaging service and is one of the best App which provides you text and voice communication. Messenger gets 100 Billion downloads on Google Play and is one of the fastest ...", "targetSearchTextId" : "72", "sentimentScore" : "0.8907743", "active" : "1", "dataSourcesId" : "288", "articleTitle" : "Facebook Messenger to be one of the most Downloaded App", "publishDate" : "2016-10-10T18:02:00", "articleAbstract" : "Facebook Messenger released five years ago in 2011. Facebook Messenger is an instant messaging service and is one of the best App which provides you text and voice communication. Messenger gets 100 Billion downloads on Google Play and is one of the fastest ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2932,"0":2932}]}
Found Id: 2932
Error Count: 0
Found search text: Facebook Advertising with id: 73
Table: msnews: 
3) Add New News Articles Batch
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": 1380000, "value": [{"name": "Facebook headed to the office with Workplace", "url": "http:\/\/www.bing.com\/cr?IG=5E41B9E6D58C4EE082DAD43D85145CA7&CID=1B0A8FA4D0A4647A27B8860ED1956504&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,5021.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.D1B31746E60C836048A6970BB874C2D6&pid=News", "width": 534, "height": 401}}, "description": "Over its 12-year life, Facebook has aimed its software squarely at consumers. But as the Silicon Valley company seeks new sources of growth — and new sources of revenue beyond advertising — it has become serious about getting into the business ...", "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":6327,"0":6327}]}
Found Id: 6327
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":[{"id":2926,"0":2926,"timestamp":"2016-10-10 13:57:58.468775-04","1":"2016-10-10 13:57:58.468775-04","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzowMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRDFCMzE3NDZFNjBDODM2MDQ4QTY5NzBCQjg3NEMyRDYmcGlkPU5ld3MiLCJ3aWR0aCI6NTM0LCJoZWlnaHQiOjQwMX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVVNBIFRvZGF5In1dLCJuYW1lIjoiRmFjZWJvb2sgaGVhZGVkIHRvIHRoZSBvZmZpY2Ugd2l0aCBXb3JrcGxhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvOTk0ZTVkZTctMDA5NC00YmZmLWQwMDktZjc0N2QzMmY2ZWVhIiwibmFtZSI6IldvcmtwbGFjZSJ9XSwiZGVzY3JpcHRpb24iOiJPbiBNb25kYXkgdGhlIGdpYW50IHNvY2lhbCBuZXR3b3JrIG9mZmljaWFsbHkgbGF1bmNoZWQgV29ya3BsYWNlIGJ5IEZhY2Vib29rLCBhIGNvbW1lcmNpYWwgdmVyc2lvbiBvZiBpdHMgcG9wdWxhciBzb2NpYWwgbmV0d29ya2luZyBzZXJ2aWNlIGluIGEgZGlyZWN0IGNoYWxsZW5nZSB0byBlbnRlcnByaXNlIHNvZnR3YXJlIG1ha2VycyBhbmQgYSBiaWQgdG8gY29sbGVjdCBzdWJzY3JpcHRpb24gcmV2ZW51ZSBmcm9tIGJ1c2luZXNzZXMuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MUQwQjcyM0IxNjk2NEI2Qzk5NTJBMDMxNzA3Q0QwODEmQ0lEPTBDMUQ1OEI3N0I5ODY2OTMyOTdGNTExRDdBQTk2NzIyJnJkPTEmaD1GTnp1UGFTRDdKaE16bG1Odmt2clpoTFJXLVdJbkt1d01KZmRVYmJvX1E4JnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cudXNhdG9kYXkuY29tJTJmc3RvcnklMmZ0ZWNoJTJmbmV3cyUyZjIwMTYlMmYxMCUyZjEwJTJmZmFjZWJvb2std29ya3BsYWNlJTJmOTE3NTQ0ODQlMmYmcD1EZXZFeCw1MDIzLjEifQ==","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzowMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRDFCMzE3NDZFNjBDODM2MDQ4QTY5NzBCQjg3NEMyRDYmcGlkPU5ld3MiLCJ3aWR0aCI6NTM0LCJoZWlnaHQiOjQwMX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVVNBIFRvZGF5In1dLCJuYW1lIjoiRmFjZWJvb2sgaGVhZGVkIHRvIHRoZSBvZmZpY2Ugd2l0aCBXb3JrcGxhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvOTk0ZTVkZTctMDA5NC00YmZmLWQwMDktZjc0N2QzMmY2ZWVhIiwibmFtZSI6IldvcmtwbGFjZSJ9XSwiZGVzY3JpcHRpb24iOiJPbiBNb25kYXkgdGhlIGdpYW50IHNvY2lhbCBuZXR3b3JrIG9mZmljaWFsbHkgbGF1bmNoZWQgV29ya3BsYWNlIGJ5IEZhY2Vib29rLCBhIGNvbW1lcmNpYWwgdmVyc2lvbiBvZiBpdHMgcG9wdWxhciBzb2NpYWwgbmV0d29ya2luZyBzZXJ2aWNlIGluIGEgZGlyZWN0IGNoYWxsZW5nZSB0byBlbnRlcnByaXNlIHNvZnR3YXJlIG1ha2VycyBhbmQgYSBiaWQgdG8gY29sbGVjdCBzdWJzY3JpcHRpb24gcmV2ZW51ZSBmcm9tIGJ1c2luZXNzZXMuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MUQwQjcyM0IxNjk2NEI2Qzk5NTJBMDMxNzA3Q0QwODEmQ0lEPTBDMUQ1OEI3N0I5ODY2OTMyOTdGNTExRDdBQTk2NzIyJnJkPTEmaD1GTnp1UGFTRDdKaE16bG1Odmt2clpoTFJXLVdJbkt1d01KZmRVYmJvX1E4JnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cudXNhdG9kYXkuY29tJTJmc3RvcnklMmZ0ZWNoJTJmbmV3cyUyZjIwMTYlMmYxMCUyZjEwJTJmZmFjZWJvb2std29ya3BsYWNlJTJmOTE3NTQ0ODQlMmYmcD1EZXZFeCw1MDIzLjEifQ==","data_json_version":"1.0","3":"1.0","data_sources_id":288,"4":288,"sentiment_score":"0.9416556","5":"0.9416556","sentiment_score_version":"1.0","6":"1.0","publish_date":"2016-10-10","7":"2016-10-10","article_title":"Facebook headed to the office with Workplace","8":"Facebook headed to the office with Workplace","article_abstract":"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.","9":"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.","article_reference_id":"USA Today_2016-10-10T17:01:00_ScienceAndTechnology","10":"USA Today_2016-10-10T17:01:00_ScienceAndTechnology","active":1,"11":1,"target_search_text_id":74,"12":74}]}
Found Entry Count: 1
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 1
Found Real Count: 1
CsaValue: [{"article_abstract":"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.","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzowMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRDFCMzE3NDZFNjBDODM2MDQ4QTY5NzBCQjg3NEMyRDYmcGlkPU5ld3MiLCJ3aWR0aCI6NTM0LCJoZWlnaHQiOjQwMX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVVNBIFRvZGF5In1dLCJuYW1lIjoiRmFjZWJvb2sgaGVhZGVkIHRvIHRoZSBvZmZpY2Ugd2l0aCBXb3JrcGxhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvOTk0ZTVkZTctMDA5NC00YmZmLWQwMDktZjc0N2QzMmY2ZWVhIiwibmFtZSI6IldvcmtwbGFjZSJ9XSwiZGVzY3JpcHRpb24iOiJPbiBNb25kYXkgdGhlIGdpYW50IHNvY2lhbCBuZXR3b3JrIG9mZmljaWFsbHkgbGF1bmNoZWQgV29ya3BsYWNlIGJ5IEZhY2Vib29rLCBhIGNvbW1lcmNpYWwgdmVyc2lvbiBvZiBpdHMgcG9wdWxhciBzb2NpYWwgbmV0d29ya2luZyBzZXJ2aWNlIGluIGEgZGlyZWN0IGNoYWxsZW5nZSB0byBlbnRlcnByaXNlIHNvZnR3YXJlIG1ha2VycyBhbmQgYSBiaWQgdG8gY29sbGVjdCBzdWJzY3JpcHRpb24gcmV2ZW51ZSBmcm9tIGJ1c2luZXNzZXMuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MUQwQjcyM0IxNjk2NEI2Qzk5NTJBMDMxNzA3Q0QwODEmQ0lEPTBDMUQ1OEI3N0I5ODY2OTMyOTdGNTExRDdBQTk2NzIyJnJkPTEmaD1GTnp1UGFTRDdKaE16bG1Odmt2clpoTFJXLVdJbkt1d01KZmRVYmJvX1E4JnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cudXNhdG9kYXkuY29tJTJmc3RvcnklMmZ0ZWNoJTJmbmV3cyUyZjIwMTYlMmYxMCUyZjEwJTJmZmFjZWJvb2std29ya3BsYWNlJTJmOTE3NTQ0ODQlMmYmcD1EZXZFeCw1MDIzLjEifQ==","id":2926,"timestamp":"2016-10-10 13:57:58.468775-04","10":"USA Today_2016-10-10T17:01:00_ScienceAndTechnology","11":1,"sentiment_score":"0.9416556","12":74,"article_reference_id":"USA Today_2016-10-10T17:01:00_ScienceAndTechnology","active":1,"data_sources_id":288,"sentiment_score_version":"1.0","0":2926,"1":"2016-10-10 13:57:58.468775-04","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzowMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uRDFCMzE3NDZFNjBDODM2MDQ4QTY5NzBCQjg3NEMyRDYmcGlkPU5ld3MiLCJ3aWR0aCI6NTM0LCJoZWlnaHQiOjQwMX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVVNBIFRvZGF5In1dLCJuYW1lIjoiRmFjZWJvb2sgaGVhZGVkIHRvIHRoZSBvZmZpY2Ugd2l0aCBXb3JrcGxhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvOTk0ZTVkZTctMDA5NC00YmZmLWQwMDktZjc0N2QzMmY2ZWVhIiwibmFtZSI6IldvcmtwbGFjZSJ9XSwiZGVzY3JpcHRpb24iOiJPbiBNb25kYXkgdGhlIGdpYW50IHNvY2lhbCBuZXR3b3JrIG9mZmljaWFsbHkgbGF1bmNoZWQgV29ya3BsYWNlIGJ5IEZhY2Vib29rLCBhIGNvbW1lcmNpYWwgdmVyc2lvbiBvZiBpdHMgcG9wdWxhciBzb2NpYWwgbmV0d29ya2luZyBzZXJ2aWNlIGluIGEgZGlyZWN0IGNoYWxsZW5nZSB0byBlbnRlcnByaXNlIHNvZnR3YXJlIG1ha2VycyBhbmQgYSBiaWQgdG8gY29sbGVjdCBzdWJzY3JpcHRpb24gcmV2ZW51ZSBmcm9tIGJ1c2luZXNzZXMuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MUQwQjcyM0IxNjk2NEI2Qzk5NTJBMDMxNzA3Q0QwODEmQ0lEPTBDMUQ1OEI3N0I5ODY2OTMyOTdGNTExRDdBQTk2NzIyJnJkPTEmaD1GTnp1UGFTRDdKaE16bG1Odmt2clpoTFJXLVdJbkt1d01KZmRVYmJvX1E4JnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cudXNhdG9kYXkuY29tJTJmc3RvcnklMmZ0ZWNoJTJmbmV3cyUyZjIwMTYlMmYxMCUyZjEwJTJmZmFjZWJvb2std29ya3BsYWNlJTJmOTE3NTQ0ODQlMmYmcD1EZXZFeCw1MDIzLjEifQ==","data_json_version":"1.0","article_title":"Facebook headed to the office with Workplace","3":"1.0","target_search_text_id":74,"4":288,"5":"0.9416556","6":"1.0","7":"2016-10-10","8":"Facebook headed to the office with Workplace","9":"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.","publish_date":"2016-10-10"}]
No text sentiment cache found to process for this search string.
Error Count: 0
Found search text: Facebook Revenue with id: 74
Table: msnews: 
3) Add New News Articles Batch
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=AD0B47B819024C27BC8F4623FE89C849&CID=07178F251BFE6C382189868F1ACF6D01&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-10T18:03:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6328,"0":6328}]}
Found Id: 6328
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-10T18:03: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
New Batch Txt Snt: { "documents" : [{ "language": "en", "id": "USA Today_2016-10-10T18:03:00_ScienceAndTechnology", "text": "Facebook headed to the office with Workplace. 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." }]}
Table: mstxt: 
2) Get Batch Text Sentiment Score
{ "data" : [{"documents":[{"score":0.9416556,"id":"USA Today_2016-10-10T18:03:00_ScienceAndTechnology"}],"errors":[]}] }
Found Array Size: 1
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6329,"0":6329}]}
Found Id: 6329
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "USA Today_2016-10-10T18:03:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxODowMzowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uRDFCMzE3NDZFNjBDODM2MDQ4QTY5NzBCQjg3NEMyRDYmcGlkPU5ld3MiLCJ3aWR0aCI6NTM0LCJoZWlnaHQiOjQwMX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVVNBIFRvZGF5In1dLCJuYW1lIjoiRmFjZWJvb2sgaGVhZGVkIHRvIHRoZSBvZmZpY2Ugd2l0aCBXb3JrcGxhY2UiLCJhYm91dCI6W3sicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvOTk0ZTVkZTctMDA5NC00YmZmLWQwMDktZjc0N2QzMmY2ZWVhIiwibmFtZSI6IldvcmtwbGFjZSJ9XSwiZGVzY3JpcHRpb24iOiJPbiBNb25kYXkgdGhlIGdpYW50IHNvY2lhbCBuZXR3b3JrIG9mZmljaWFsbHkgbGF1bmNoZWQgV29ya3BsYWNlIGJ5IEZhY2Vib29rLCBhIGNvbW1lcmNpYWwgdmVyc2lvbiBvZiBpdHMgcG9wdWxhciBzb2NpYWwgbmV0d29ya2luZyBzZXJ2aWNlIGluIGEgZGlyZWN0IGNoYWxsZW5nZSB0byBlbnRlcnByaXNlIHNvZnR3YXJlIG1ha2VycyBhbmQgYSBiaWQgdG8gY29sbGVjdCBzdWJzY3JpcHRpb24gcmV2ZW51ZSBmcm9tIGJ1c2luZXNzZXMuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I/SUc9QUQwQjQ3QjgxOTAyNEMyN0JDOEY0NjIzRkU4OUM4NDkmQ0lEPTA3MTc4RjI1MUJGRTZDMzgyMTg5ODY4RjFBQ0Y2RDAxJnJkPTEmaD1GTnp1UGFTRDdKaE16bG1Odmt2clpoTFJXLVdJbkt1d01KZmRVYmJvX1E4JnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cudXNhdG9kYXkuY29tJTJmc3RvcnklMmZ0ZWNoJTJmbmV3cyUyZjIwMTYlMmYxMCUyZjEwJTJmZmFjZWJvb2std29ya3BsYWNlJTJmOTE3NTQ0ODQlMmYmcD1EZXZFeCw1MDIzLjEifQ==", "dataJsonVer" : "1.0", "sentimentString" : "Facebook headed to the office with Workplace. 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.", "targetSearchTextId" : "74", "sentimentScore" : "0.9416556", "active" : "1", "dataSourcesId" : "288", "articleTitle" : "Facebook headed to the office with Workplace", "publishDate" : "2016-10-10T18:03: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":2933,"0":2933}]}
Found Id: 2933
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: 
3) Add New News Articles Batch
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": 1110000, "value": [{"name": "Olloclip's new lenses attach quickly to your iPhone 7", "url": "https:\/\/www.bing.com\/cr?IG=1BD14077C33A4B80B792AD20B969CD83&CID=21EAD01716C66F3A0D6CD9BD17F76E35&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":6330,"0":6330}]}
Found Id: 6330
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":[{"id":2927,"0":2927,"timestamp":"2016-10-10 13:58:10.063498-04","1":"2016-10-10 13:58:10.063498-04","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0MDowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uMzMyMURDMEU0NjRDOTA0QjI5NkMyNTAzQUJFNTgyMUYmcGlkPU5ld3MiLCJ3aWR0aCI6NjgyLCJoZWlnaHQiOjQ1NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRW5nYWRnZXQifV0sIm5hbWUiOiJPbGxvY2xpcCdzIG5ldyBsZW5zZXMgYXR0YWNoIHF1aWNrbHkgdG8geW91ciBpUGhvbmUgNyIsImRlc2NyaXB0aW9uIjoiTm93IHRoYXQgdGhlcmUgYXJlIG5ldyBpUGhvbmVzIHdpdGggcmV2aXNlZCBjYW1lcmFzLCBtYW55IHNtYXJ0cGhvbmUgcGhvdG9ncmFwaGVycyBhcmUgZ29pbmcgdG8gd2FudCBuZXcgT2xsb2NsaXAgbGVuc2VzLiBUaGFua2Z1bGx5LCB0aGV5J3ZlIGFycml2ZWQuLi4gYW5kIE9sbG9jbGlwIGRpZG4ndCBqdXN0IHR3ZWFrIHRoZSBjb25uZWN0b3JzIGFuZCBjYWxsIGl0IGEgZGF5LiBJdHMgbmV3IENvcmUsIEFjdGl2ZSBhbmQgTWFjcm8gUHJvIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwczpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz04QjY0OEEwMTU2MTE0NDM5QTVFNTZDOTU2MEJFNTIwMyZDSUQ9M0M4MzVBNEQ5REUxNjc4NTM3MTk1M0U3OUNEMDY2REUmcmQ9MSZoPVZqX0lENzcwRWtuZ0QzMHMxcXBIQjNxZkRGZ2k5SDhTcTA3Z18zWmt3VzAmdj0xJnI9aHR0cHMlM2ElMmYlMmZ3d3cuZW5nYWRnZXQuY29tJTJmMjAxNiUyZjEwJTJmMTAlMmZvbGxvY2xpcC1pcGhvbmUtNy1sZW5zZXMlMmYmcD1EZXZFeCw1MDIzLjEifQ==","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0MDowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uMzMyMURDMEU0NjRDOTA0QjI5NkMyNTAzQUJFNTgyMUYmcGlkPU5ld3MiLCJ3aWR0aCI6NjgyLCJoZWlnaHQiOjQ1NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRW5nYWRnZXQifV0sIm5hbWUiOiJPbGxvY2xpcCdzIG5ldyBsZW5zZXMgYXR0YWNoIHF1aWNrbHkgdG8geW91ciBpUGhvbmUgNyIsImRlc2NyaXB0aW9uIjoiTm93IHRoYXQgdGhlcmUgYXJlIG5ldyBpUGhvbmVzIHdpdGggcmV2aXNlZCBjYW1lcmFzLCBtYW55IHNtYXJ0cGhvbmUgcGhvdG9ncmFwaGVycyBhcmUgZ29pbmcgdG8gd2FudCBuZXcgT2xsb2NsaXAgbGVuc2VzLiBUaGFua2Z1bGx5LCB0aGV5J3ZlIGFycml2ZWQuLi4gYW5kIE9sbG9jbGlwIGRpZG4ndCBqdXN0IHR3ZWFrIHRoZSBjb25uZWN0b3JzIGFuZCBjYWxsIGl0IGEgZGF5LiBJdHMgbmV3IENvcmUsIEFjdGl2ZSBhbmQgTWFjcm8gUHJvIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwczpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz04QjY0OEEwMTU2MTE0NDM5QTVFNTZDOTU2MEJFNTIwMyZDSUQ9M0M4MzVBNEQ5REUxNjc4NTM3MTk1M0U3OUNEMDY2REUmcmQ9MSZoPVZqX0lENzcwRWtuZ0QzMHMxcXBIQjNxZkRGZ2k5SDhTcTA3Z18zWmt3VzAmdj0xJnI9aHR0cHMlM2ElMmYlMmZ3d3cuZW5nYWRnZXQuY29tJTJmMjAxNiUyZjEwJTJmMTAlMmZvbGxvY2xpcC1pcGhvbmUtNy1sZW5zZXMlMmYmcD1EZXZFeCw1MDIzLjEifQ==","data_json_version":"1.0","3":"1.0","data_sources_id":288,"4":288,"sentiment_score":"0.6977513","5":"0.6977513","sentiment_score_version":"1.0","6":"1.0","publish_date":"2016-10-10","7":"2016-10-10","article_title":"Olloclip's new lenses attach quickly to your iPhone 7","8":"Olloclip's new lenses attach quickly to your iPhone 7","article_abstract":"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 ...","9":"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 ...","article_reference_id":"Engadget_2016-10-10T17:40:00_ScienceAndTechnology","10":"Engadget_2016-10-10T17:40:00_ScienceAndTechnology","active":1,"11":1,"target_search_text_id":75,"12":75}]}
Found Entry Count: 1
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 1
Found Real Count: 1
CsaValue: [{"article_abstract":"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 ...","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0MDowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uMzMyMURDMEU0NjRDOTA0QjI5NkMyNTAzQUJFNTgyMUYmcGlkPU5ld3MiLCJ3aWR0aCI6NjgyLCJoZWlnaHQiOjQ1NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRW5nYWRnZXQifV0sIm5hbWUiOiJPbGxvY2xpcCdzIG5ldyBsZW5zZXMgYXR0YWNoIHF1aWNrbHkgdG8geW91ciBpUGhvbmUgNyIsImRlc2NyaXB0aW9uIjoiTm93IHRoYXQgdGhlcmUgYXJlIG5ldyBpUGhvbmVzIHdpdGggcmV2aXNlZCBjYW1lcmFzLCBtYW55IHNtYXJ0cGhvbmUgcGhvdG9ncmFwaGVycyBhcmUgZ29pbmcgdG8gd2FudCBuZXcgT2xsb2NsaXAgbGVuc2VzLiBUaGFua2Z1bGx5LCB0aGV5J3ZlIGFycml2ZWQuLi4gYW5kIE9sbG9jbGlwIGRpZG4ndCBqdXN0IHR3ZWFrIHRoZSBjb25uZWN0b3JzIGFuZCBjYWxsIGl0IGEgZGF5LiBJdHMgbmV3IENvcmUsIEFjdGl2ZSBhbmQgTWFjcm8gUHJvIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwczpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz04QjY0OEEwMTU2MTE0NDM5QTVFNTZDOTU2MEJFNTIwMyZDSUQ9M0M4MzVBNEQ5REUxNjc4NTM3MTk1M0U3OUNEMDY2REUmcmQ9MSZoPVZqX0lENzcwRWtuZ0QzMHMxcXBIQjNxZkRGZ2k5SDhTcTA3Z18zWmt3VzAmdj0xJnI9aHR0cHMlM2ElMmYlMmZ3d3cuZW5nYWRnZXQuY29tJTJmMjAxNiUyZjEwJTJmMTAlMmZvbGxvY2xpcC1pcGhvbmUtNy1sZW5zZXMlMmYmcD1EZXZFeCw1MDIzLjEifQ==","id":2927,"timestamp":"2016-10-10 13:58:10.063498-04","10":"Engadget_2016-10-10T17:40:00_ScienceAndTechnology","11":1,"sentiment_score":"0.6977513","12":75,"article_reference_id":"Engadget_2016-10-10T17:40:00_ScienceAndTechnology","active":1,"data_sources_id":288,"sentiment_score_version":"1.0","0":2927,"1":"2016-10-10 13:58:10.063498-04","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzo0MDowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uMzMyMURDMEU0NjRDOTA0QjI5NkMyNTAzQUJFNTgyMUYmcGlkPU5ld3MiLCJ3aWR0aCI6NjgyLCJoZWlnaHQiOjQ1NX19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiRW5nYWRnZXQifV0sIm5hbWUiOiJPbGxvY2xpcCdzIG5ldyBsZW5zZXMgYXR0YWNoIHF1aWNrbHkgdG8geW91ciBpUGhvbmUgNyIsImRlc2NyaXB0aW9uIjoiTm93IHRoYXQgdGhlcmUgYXJlIG5ldyBpUGhvbmVzIHdpdGggcmV2aXNlZCBjYW1lcmFzLCBtYW55IHNtYXJ0cGhvbmUgcGhvdG9ncmFwaGVycyBhcmUgZ29pbmcgdG8gd2FudCBuZXcgT2xsb2NsaXAgbGVuc2VzLiBUaGFua2Z1bGx5LCB0aGV5J3ZlIGFycml2ZWQuLi4gYW5kIE9sbG9jbGlwIGRpZG4ndCBqdXN0IHR3ZWFrIHRoZSBjb25uZWN0b3JzIGFuZCBjYWxsIGl0IGEgZGF5LiBJdHMgbmV3IENvcmUsIEFjdGl2ZSBhbmQgTWFjcm8gUHJvIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwczpcL1wvd3d3LmJpbmcuY29tXC9jcj9JRz04QjY0OEEwMTU2MTE0NDM5QTVFNTZDOTU2MEJFNTIwMyZDSUQ9M0M4MzVBNEQ5REUxNjc4NTM3MTk1M0U3OUNEMDY2REUmcmQ9MSZoPVZqX0lENzcwRWtuZ0QzMHMxcXBIQjNxZkRGZ2k5SDhTcTA3Z18zWmt3VzAmdj0xJnI9aHR0cHMlM2ElMmYlMmZ3d3cuZW5nYWRnZXQuY29tJTJmMjAxNiUyZjEwJTJmMTAlMmZvbGxvY2xpcC1pcGhvbmUtNy1sZW5zZXMlMmYmcD1EZXZFeCw1MDIzLjEifQ==","data_json_version":"1.0","article_title":"Olloclip's new lenses attach quickly to your iPhone 7","3":"1.0","target_search_text_id":75,"4":288,"5":"0.6977513","6":"1.0","7":"2016-10-10","8":"Olloclip's new lenses attach quickly to your iPhone 7","9":"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 ...","publish_date":"2016-10-10"}]
No text sentiment cache found to process for this search string.
Error Count: 0
Found search text: iOS 10 with id: 76
Table: msnews: 
3) Add New News Articles Batch
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=A61954251AA140A2873250BA85EE0054&CID=257705F512EF67E015160C5F13DE66B5&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=A61954251AA140A2873250BA85EE0054&CID=257705F512EF67E015160C5F13DE66B5&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":6331,"0":6331}]}
Found Id: 6331
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":[{"id":2928,"0":2928,"timestamp":"2016-10-10 13:58:21.55297-04","1":"2016-10-10 13:58:21.55297-04","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNjo1MjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uNEY0Q0Y5MkMwNUU0MEFENjg1Q0U3RDcwRjE2QzVCRUImcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM1MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVGhlIEJ1c2luZXNzIEluc2lkZXIifV0sImNsdXN0ZXJlZEFydGljbGVzIjpbeyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoxMDowMCIsInByb3ZpZGVyIjpbeyJfdHlwZSI6Ik9yZ2FuaXphdGlvbiIsIm5hbWUiOiJ0b2RheXNpcGhvbmUuY29tIn1dLCJuYW1lIjoiaU9TIDEwIG5vdyBoYXMgZmFzdGVzdCBhZG9wdGlvbiByYXRlIG9mIGFueSBpT1MgdXBkYXRlLCBpbnN0YWxsZWQgb24gdHdvIHRoaXJkcyBvZiBkZXZpY2VzIiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzE2ZTQ2MjQ2LTIyNTctNjQzYi00ODhjLWYxNTcyZDhhOTgxNyIsIm5hbWUiOiJpT1MifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2UyN2M1ZDk2LWZhNzAtYTUyZS0zZGIzLWVlOTlhNDdlZDI2ZSIsIm5hbWUiOiJBZG9wdGlvbiJ9XSwiZGVzY3JpcHRpb24iOiJpT1MgMTAgaXMgbm93IGluc3RhbGxlZCBvbiBhIHJlY29yZCBicmVha2luZyA2Ni43JSBvZiBzdXBwb3J0IGRldmljZXMsIHR3ZW50eS1zZXZlbiBkYXlzIGFmdGVyIGlPUyAxMCB3YXMgcmVsZWFzZWQgYWNjb3JkaW5nIHRvIEZpa3N1LiBNaXhwYW5lbCBhbHNvIHNheXMgdGhhdCBpT1MgMTAgaXMgYXQgNjYlIGFkb3B0aW9uIGFzIG9mIFN1bmRheS4gTmVhcmx5IGEgbW9udGggYWZ0ZXIgcmVsZWFzZSwgaU9TIDEwIGhhcyBiZWNvbWUgdGhlIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTM0NTIwRTZGQTFGMTQ3MDhBNkYwMjk3REI2M0REQTk2JkNJRD0xRTEzOUE3QzRDQUI2QkFFMTFERjkzRDY0RDlBNkFCNiZyZD0xJmg9Y0t0aUZJY3Y0aXVtUW1Tbm0xM2dveG1fNU9ZOFd0Q1RGX19xcHZPSU5wQSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LnRvZGF5c2lwaG9uZS5jb20lMmYyMDE2JTJmMTAlMmZpb3MtMTAtZmFzdGVzdC1hZG9wdGlvbi1yYXRlLWFueS1pb3MtdXBkYXRlJTJmJnA9RGV2RXgsNTAyMy4xIn1dLCJuYW1lIjoiUGVvcGxlIGFyZSBhZG9wdGluZyBpT1MgMTAgYXQgYSByZWNvcmQgcmF0ZSIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZDQ3OTM4Mi1kMzQwLTU4NDgtYzk5ZC1lZDM3MWIwMGI3NTIiLCJuYW1lIjoiQW5kcm9pZCJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvMTZlNDYyNDYtMjI1Ny02NDNiLTQ4OGMtZjE1NzJkOGE5ODE3IiwibmFtZSI6ImlPUyJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvZTI3YzVkOTYtZmE3MC1hNTJlLTNkYjMtZWU5OWE0N2VkMjZlIiwibmFtZSI6IkFkb3B0aW9uIn1dLCJkZXNjcmlwdGlvbiI6ImlPUyAxMCBpcyBub3cgaW5zdGFsbGVkIG9uIHJvdWdobHkgdHdvLXRoaXJkcyBvZiBhY3RpdmUgaU9TIGRldmljZXMsIGFjY29yZGluZyB0byBkYXRhIGZyb20gdHJhY2tpbmcgZmlybXMgTWl4cGFuZWwgYW5kIEZpa3N1IERTUC4gTWl4cGFuZWwgcGVncyA2NS4yMSUgb2YgaU9TIGRldmljZSB1c2VycyBhcyBoYXZpbmcgQXBwbGVcdTIwMTlzIGxhdGVzdCBzb2Z0d2FyZSB1cGRhdGUsIHdoaWxlIEZpa3N1IERTUCBoYXMgaXQgYXQgNjYuNyUuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MzQ1MjBFNkZBMUYxNDcwOEE2RjAyOTdEQjYzRERBOTYmQ0lEPTFFMTM5QTdDNENBQjZCQUUxMURGOTNENjREOUE2QUI2JnJkPTEmaD1qekc3eG1Fb2lzUDU4S081SkpvV3g5X19Vd1lycWVfTktETmYtVVZRd0hFJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYnVzaW5lc3NpbnNpZGVyLmNvbSUyZmFwcGxlLWlvcy0xMC1hZG9wdGlvbi1yYXRlLWFuZHJvaWQtMjAxNi0xMCZwPURldkV4LDUwMjIuMSJ9","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNjo1MjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uNEY0Q0Y5MkMwNUU0MEFENjg1Q0U3RDcwRjE2QzVCRUImcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM1MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVGhlIEJ1c2luZXNzIEluc2lkZXIifV0sImNsdXN0ZXJlZEFydGljbGVzIjpbeyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoxMDowMCIsInByb3ZpZGVyIjpbeyJfdHlwZSI6Ik9yZ2FuaXphdGlvbiIsIm5hbWUiOiJ0b2RheXNpcGhvbmUuY29tIn1dLCJuYW1lIjoiaU9TIDEwIG5vdyBoYXMgZmFzdGVzdCBhZG9wdGlvbiByYXRlIG9mIGFueSBpT1MgdXBkYXRlLCBpbnN0YWxsZWQgb24gdHdvIHRoaXJkcyBvZiBkZXZpY2VzIiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzE2ZTQ2MjQ2LTIyNTctNjQzYi00ODhjLWYxNTcyZDhhOTgxNyIsIm5hbWUiOiJpT1MifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2UyN2M1ZDk2LWZhNzAtYTUyZS0zZGIzLWVlOTlhNDdlZDI2ZSIsIm5hbWUiOiJBZG9wdGlvbiJ9XSwiZGVzY3JpcHRpb24iOiJpT1MgMTAgaXMgbm93IGluc3RhbGxlZCBvbiBhIHJlY29yZCBicmVha2luZyA2Ni43JSBvZiBzdXBwb3J0IGRldmljZXMsIHR3ZW50eS1zZXZlbiBkYXlzIGFmdGVyIGlPUyAxMCB3YXMgcmVsZWFzZWQgYWNjb3JkaW5nIHRvIEZpa3N1LiBNaXhwYW5lbCBhbHNvIHNheXMgdGhhdCBpT1MgMTAgaXMgYXQgNjYlIGFkb3B0aW9uIGFzIG9mIFN1bmRheS4gTmVhcmx5IGEgbW9udGggYWZ0ZXIgcmVsZWFzZSwgaU9TIDEwIGhhcyBiZWNvbWUgdGhlIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTM0NTIwRTZGQTFGMTQ3MDhBNkYwMjk3REI2M0REQTk2JkNJRD0xRTEzOUE3QzRDQUI2QkFFMTFERjkzRDY0RDlBNkFCNiZyZD0xJmg9Y0t0aUZJY3Y0aXVtUW1Tbm0xM2dveG1fNU9ZOFd0Q1RGX19xcHZPSU5wQSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LnRvZGF5c2lwaG9uZS5jb20lMmYyMDE2JTJmMTAlMmZpb3MtMTAtZmFzdGVzdC1hZG9wdGlvbi1yYXRlLWFueS1pb3MtdXBkYXRlJTJmJnA9RGV2RXgsNTAyMy4xIn1dLCJuYW1lIjoiUGVvcGxlIGFyZSBhZG9wdGluZyBpT1MgMTAgYXQgYSByZWNvcmQgcmF0ZSIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZDQ3OTM4Mi1kMzQwLTU4NDgtYzk5ZC1lZDM3MWIwMGI3NTIiLCJuYW1lIjoiQW5kcm9pZCJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvMTZlNDYyNDYtMjI1Ny02NDNiLTQ4OGMtZjE1NzJkOGE5ODE3IiwibmFtZSI6ImlPUyJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvZTI3YzVkOTYtZmE3MC1hNTJlLTNkYjMtZWU5OWE0N2VkMjZlIiwibmFtZSI6IkFkb3B0aW9uIn1dLCJkZXNjcmlwdGlvbiI6ImlPUyAxMCBpcyBub3cgaW5zdGFsbGVkIG9uIHJvdWdobHkgdHdvLXRoaXJkcyBvZiBhY3RpdmUgaU9TIGRldmljZXMsIGFjY29yZGluZyB0byBkYXRhIGZyb20gdHJhY2tpbmcgZmlybXMgTWl4cGFuZWwgYW5kIEZpa3N1IERTUC4gTWl4cGFuZWwgcGVncyA2NS4yMSUgb2YgaU9TIGRldmljZSB1c2VycyBhcyBoYXZpbmcgQXBwbGVcdTIwMTlzIGxhdGVzdCBzb2Z0d2FyZSB1cGRhdGUsIHdoaWxlIEZpa3N1IERTUCBoYXMgaXQgYXQgNjYuNyUuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MzQ1MjBFNkZBMUYxNDcwOEE2RjAyOTdEQjYzRERBOTYmQ0lEPTFFMTM5QTdDNENBQjZCQUUxMURGOTNENjREOUE2QUI2JnJkPTEmaD1qekc3eG1Fb2lzUDU4S081SkpvV3g5X19Vd1lycWVfTktETmYtVVZRd0hFJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYnVzaW5lc3NpbnNpZGVyLmNvbSUyZmFwcGxlLWlvcy0xMC1hZG9wdGlvbi1yYXRlLWFuZHJvaWQtMjAxNi0xMCZwPURldkV4LDUwMjIuMSJ9","data_json_version":"1.0","3":"1.0","data_sources_id":288,"4":288,"sentiment_score":"0.0661445","5":"0.0661445","sentiment_score_version":"1.0","6":"1.0","publish_date":"2016-10-10","7":"2016-10-10","article_title":"People are adopting iOS 10 at a record rate","8":"People are adopting iOS 10 at a record rate","article_abstract":"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\u2019s latest software update, while Fiksu DSP has it at 66.7%.","9":"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\u2019s latest software update, while Fiksu DSP has it at 66.7%.","article_reference_id":"The Business Insider_2016-10-10T16:52:00_ScienceAndTechnology","10":"The Business Insider_2016-10-10T16:52:00_ScienceAndTechnology","active":1,"11":1,"target_search_text_id":76,"12":76}]}
Found Entry Count: 1
Table: otherrpc: 
9) Get String Value from Variable
Found Count: 1
Found Real Count: 1
CsaValue: [{"article_abstract":"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\u2019s latest software update, while Fiksu DSP has it at 66.7%.","data_json":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNjo1MjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uNEY0Q0Y5MkMwNUU0MEFENjg1Q0U3RDcwRjE2QzVCRUImcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM1MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVGhlIEJ1c2luZXNzIEluc2lkZXIifV0sImNsdXN0ZXJlZEFydGljbGVzIjpbeyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoxMDowMCIsInByb3ZpZGVyIjpbeyJfdHlwZSI6Ik9yZ2FuaXphdGlvbiIsIm5hbWUiOiJ0b2RheXNpcGhvbmUuY29tIn1dLCJuYW1lIjoiaU9TIDEwIG5vdyBoYXMgZmFzdGVzdCBhZG9wdGlvbiByYXRlIG9mIGFueSBpT1MgdXBkYXRlLCBpbnN0YWxsZWQgb24gdHdvIHRoaXJkcyBvZiBkZXZpY2VzIiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzE2ZTQ2MjQ2LTIyNTctNjQzYi00ODhjLWYxNTcyZDhhOTgxNyIsIm5hbWUiOiJpT1MifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2UyN2M1ZDk2LWZhNzAtYTUyZS0zZGIzLWVlOTlhNDdlZDI2ZSIsIm5hbWUiOiJBZG9wdGlvbiJ9XSwiZGVzY3JpcHRpb24iOiJpT1MgMTAgaXMgbm93IGluc3RhbGxlZCBvbiBhIHJlY29yZCBicmVha2luZyA2Ni43JSBvZiBzdXBwb3J0IGRldmljZXMsIHR3ZW50eS1zZXZlbiBkYXlzIGFmdGVyIGlPUyAxMCB3YXMgcmVsZWFzZWQgYWNjb3JkaW5nIHRvIEZpa3N1LiBNaXhwYW5lbCBhbHNvIHNheXMgdGhhdCBpT1MgMTAgaXMgYXQgNjYlIGFkb3B0aW9uIGFzIG9mIFN1bmRheS4gTmVhcmx5IGEgbW9udGggYWZ0ZXIgcmVsZWFzZSwgaU9TIDEwIGhhcyBiZWNvbWUgdGhlIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTM0NTIwRTZGQTFGMTQ3MDhBNkYwMjk3REI2M0REQTk2JkNJRD0xRTEzOUE3QzRDQUI2QkFFMTFERjkzRDY0RDlBNkFCNiZyZD0xJmg9Y0t0aUZJY3Y0aXVtUW1Tbm0xM2dveG1fNU9ZOFd0Q1RGX19xcHZPSU5wQSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LnRvZGF5c2lwaG9uZS5jb20lMmYyMDE2JTJmMTAlMmZpb3MtMTAtZmFzdGVzdC1hZG9wdGlvbi1yYXRlLWFueS1pb3MtdXBkYXRlJTJmJnA9RGV2RXgsNTAyMy4xIn1dLCJuYW1lIjoiUGVvcGxlIGFyZSBhZG9wdGluZyBpT1MgMTAgYXQgYSByZWNvcmQgcmF0ZSIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZDQ3OTM4Mi1kMzQwLTU4NDgtYzk5ZC1lZDM3MWIwMGI3NTIiLCJuYW1lIjoiQW5kcm9pZCJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvMTZlNDYyNDYtMjI1Ny02NDNiLTQ4OGMtZjE1NzJkOGE5ODE3IiwibmFtZSI6ImlPUyJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvZTI3YzVkOTYtZmE3MC1hNTJlLTNkYjMtZWU5OWE0N2VkMjZlIiwibmFtZSI6IkFkb3B0aW9uIn1dLCJkZXNjcmlwdGlvbiI6ImlPUyAxMCBpcyBub3cgaW5zdGFsbGVkIG9uIHJvdWdobHkgdHdvLXRoaXJkcyBvZiBhY3RpdmUgaU9TIGRldmljZXMsIGFjY29yZGluZyB0byBkYXRhIGZyb20gdHJhY2tpbmcgZmlybXMgTWl4cGFuZWwgYW5kIEZpa3N1IERTUC4gTWl4cGFuZWwgcGVncyA2NS4yMSUgb2YgaU9TIGRldmljZSB1c2VycyBhcyBoYXZpbmcgQXBwbGVcdTIwMTlzIGxhdGVzdCBzb2Z0d2FyZSB1cGRhdGUsIHdoaWxlIEZpa3N1IERTUCBoYXMgaXQgYXQgNjYuNyUuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MzQ1MjBFNkZBMUYxNDcwOEE2RjAyOTdEQjYzRERBOTYmQ0lEPTFFMTM5QTdDNENBQjZCQUUxMURGOTNENjREOUE2QUI2JnJkPTEmaD1qekc3eG1Fb2lzUDU4S081SkpvV3g5X19Vd1lycWVfTktETmYtVVZRd0hFJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYnVzaW5lc3NpbnNpZGVyLmNvbSUyZmFwcGxlLWlvcy0xMC1hZG9wdGlvbi1yYXRlLWFuZHJvaWQtMjAxNi0xMCZwPURldkV4LDUwMjIuMSJ9","id":2928,"timestamp":"2016-10-10 13:58:21.55297-04","10":"The Business Insider_2016-10-10T16:52:00_ScienceAndTechnology","11":1,"sentiment_score":"0.0661445","12":76,"article_reference_id":"The Business Insider_2016-10-10T16:52:00_ScienceAndTechnology","active":1,"data_sources_id":288,"sentiment_score_version":"1.0","0":2928,"1":"2016-10-10 13:58:21.55297-04","2":"eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNjo1MjowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg\/aWQ9T04uNEY0Q0Y5MkMwNUU0MEFENjg1Q0U3RDcwRjE2QzVCRUImcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM1MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVGhlIEJ1c2luZXNzIEluc2lkZXIifV0sImNsdXN0ZXJlZEFydGljbGVzIjpbeyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxNzoxMDowMCIsInByb3ZpZGVyIjpbeyJfdHlwZSI6Ik9yZ2FuaXphdGlvbiIsIm5hbWUiOiJ0b2RheXNpcGhvbmUuY29tIn1dLCJuYW1lIjoiaU9TIDEwIG5vdyBoYXMgZmFzdGVzdCBhZG9wdGlvbiByYXRlIG9mIGFueSBpT1MgdXBkYXRlLCBpbnN0YWxsZWQgb24gdHdvIHRoaXJkcyBvZiBkZXZpY2VzIiwiYWJvdXQiOlt7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcLzE2ZTQ2MjQ2LTIyNTctNjQzYi00ODhjLWYxNTcyZDhhOTgxNyIsIm5hbWUiOiJpT1MifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2UyN2M1ZDk2LWZhNzAtYTUyZS0zZGIzLWVlOTlhNDdlZDI2ZSIsIm5hbWUiOiJBZG9wdGlvbiJ9XSwiZGVzY3JpcHRpb24iOiJpT1MgMTAgaXMgbm93IGluc3RhbGxlZCBvbiBhIHJlY29yZCBicmVha2luZyA2Ni43JSBvZiBzdXBwb3J0IGRldmljZXMsIHR3ZW50eS1zZXZlbiBkYXlzIGFmdGVyIGlPUyAxMCB3YXMgcmVsZWFzZWQgYWNjb3JkaW5nIHRvIEZpa3N1LiBNaXhwYW5lbCBhbHNvIHNheXMgdGhhdCBpT1MgMTAgaXMgYXQgNjYlIGFkb3B0aW9uIGFzIG9mIFN1bmRheS4gTmVhcmx5IGEgbW9udGggYWZ0ZXIgcmVsZWFzZSwgaU9TIDEwIGhhcyBiZWNvbWUgdGhlIC4uLiIsImNhdGVnb3J5IjoiU2NpZW5jZUFuZFRlY2hub2xvZ3kiLCJ1cmwiOiJodHRwOlwvXC93d3cuYmluZy5jb21cL2NyP0lHPTM0NTIwRTZGQTFGMTQ3MDhBNkYwMjk3REI2M0REQTk2JkNJRD0xRTEzOUE3QzRDQUI2QkFFMTFERjkzRDY0RDlBNkFCNiZyZD0xJmg9Y0t0aUZJY3Y0aXVtUW1Tbm0xM2dveG1fNU9ZOFd0Q1RGX19xcHZPSU5wQSZ2PTEmcj1odHRwJTNhJTJmJTJmd3d3LnRvZGF5c2lwaG9uZS5jb20lMmYyMDE2JTJmMTAlMmZpb3MtMTAtZmFzdGVzdC1hZG9wdGlvbi1yYXRlLWFueS1pb3MtdXBkYXRlJTJmJnA9RGV2RXgsNTAyMy4xIn1dLCJuYW1lIjoiUGVvcGxlIGFyZSBhZG9wdGluZyBpT1MgMTAgYXQgYSByZWNvcmQgcmF0ZSIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC9jZDQ3OTM4Mi1kMzQwLTU4NDgtYzk5ZC1lZDM3MWIwMGI3NTIiLCJuYW1lIjoiQW5kcm9pZCJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvMTZlNDYyNDYtMjI1Ny02NDNiLTQ4OGMtZjE1NzJkOGE5ODE3IiwibmFtZSI6ImlPUyJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvZTI3YzVkOTYtZmE3MC1hNTJlLTNkYjMtZWU5OWE0N2VkMjZlIiwibmFtZSI6IkFkb3B0aW9uIn1dLCJkZXNjcmlwdGlvbiI6ImlPUyAxMCBpcyBub3cgaW5zdGFsbGVkIG9uIHJvdWdobHkgdHdvLXRoaXJkcyBvZiBhY3RpdmUgaU9TIGRldmljZXMsIGFjY29yZGluZyB0byBkYXRhIGZyb20gdHJhY2tpbmcgZmlybXMgTWl4cGFuZWwgYW5kIEZpa3N1IERTUC4gTWl4cGFuZWwgcGVncyA2NS4yMSUgb2YgaU9TIGRldmljZSB1c2VycyBhcyBoYXZpbmcgQXBwbGVcdTIwMTlzIGxhdGVzdCBzb2Z0d2FyZSB1cGRhdGUsIHdoaWxlIEZpa3N1IERTUCBoYXMgaXQgYXQgNjYuNyUuIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I\/SUc9MzQ1MjBFNkZBMUYxNDcwOEE2RjAyOTdEQjYzRERBOTYmQ0lEPTFFMTM5QTdDNENBQjZCQUUxMURGOTNENjREOUE2QUI2JnJkPTEmaD1qekc3eG1Fb2lzUDU4S081SkpvV3g5X19Vd1lycWVfTktETmYtVVZRd0hFJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYnVzaW5lc3NpbnNpZGVyLmNvbSUyZmFwcGxlLWlvcy0xMC1hZG9wdGlvbi1yYXRlLWFuZHJvaWQtMjAxNi0xMCZwPURldkV4LDUwMjIuMSJ9","data_json_version":"1.0","article_title":"People are adopting iOS 10 at a record rate","3":"1.0","target_search_text_id":76,"4":288,"5":"0.0661445","6":"1.0","7":"2016-10-10","8":"People are adopting iOS 10 at a record rate","9":"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\u2019s latest software update, while Fiksu DSP has it at 66.7%.","publish_date":"2016-10-10"}]
No text sentiment cache found to process for this search string.
Error Count: 0
Found search text: Apple with id: 77
Table: msnews: 
3) Add New News Articles Batch
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 stock rises as Samsung bungles its exploding smartphone recall", "url": "http:\/\/www.bing.com\/cr?IG=D6697E4D126C4A309002D6D40A5D11D8&CID=082002C264476D6226630B6865766CDF&rd=1&h=16aeldvDVq3RIQkbwdKdV8tXRq1FxXIgKfir7t2aNaI&v=1&r=http%3a%2f%2fwww.businessinsider.com%2fapple-stock-rising-now-matches-december-price-2016-10&p=DevEx,5025.1", "image": {"thumbnail": {"contentUrl": "https:\/\/www.bing.com\/th?id=ON.2522D92AE60908CDA92418F91FB89053&pid=News", "width": 700, "height": 350}}, "description": "Apple stock rose to $116.23 in mid-day trading as its main rival for the high-end smartphone market, Samsung, continues to reel from reports that its latest device continues to have issues with its battery. The $2.17, or $1.90% rise, comes after Apple ...", "about": [{"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/458fb3ec-80f7-2a40-2f5e-ea0bf47fe7f6", "name": "Stock"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/cd550390-8f23-9faa-4b3d-5d5ef422c989", "name": "Match"}, {"readLink": "https:\/\/api.cognitive.microsoft.com\/api\/v5\/entities\/6fa57c29-e813-4a1d-7fba-3541ca4c1dc3", "name": "Apple Inc."}], "provider": [{"_type": "Organization", "name": "The Business Insider"}], "datePublished": "2016-10-10T18:01:00", "category": "ScienceAndTechnology"}]}
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "288"}}
{"data":[{"id":6332,"0":6332}]}
Found Id: 6332
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-10T18:01:00_ScienceAndTechnology", "title" : "Apple stock rises as Samsung bungles its exploding smartphone recall"}}
{"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
New Batch Txt Snt: { "documents" : [{ "language": "en", "id": "The Business Insider_2016-10-10T18:01:00_ScienceAndTechnology", "text": "Apple stock rises as Samsung bungles its exploding smartphone recall. Apple stock rose to $116.23 in mid-day trading as its main rival for the high-end smartphone market, Samsung, continues to reel from reports that its latest device continues to have issues with its battery. The $2.17, or $1.90% rise, comes after Apple ..." }]}
Table: mstxt: 
2) Get Batch Text Sentiment Score
{ "data" : [{"documents":[{"score":0.09044259,"id":"The Business Insider_2016-10-10T18:01:00_ScienceAndTechnology"}],"errors":[]}] }
Found Array Size: 1
Table: datasourcesusage: 
1) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "dataSourcesUsageAdd", "params" : {"dataSourcesId" : "289"}}
{"data":[{"id":6333,"0":6333}]}
Found Id: 6333
Table: articles: 
3) Add Record
Skey: f962a2508bad55ff29299acf517b64c6
JsonData: {"key" : "f962a2508bad55ff29299acf517b64c6", "action" : "articlesAdd", "params" : {"articleReferenceId" : "The Business Insider_2016-10-10T18:01:00_ScienceAndTechnology", "dataJson" : "eyJkYXRlUHVibGlzaGVkIjoiMjAxNi0xMC0xMFQxODowMTowMCIsImltYWdlIjp7InRodW1ibmFpbCI6eyJjb250ZW50VXJsIjoiaHR0cHM6XC9cL3d3dy5iaW5nLmNvbVwvdGg/aWQ9T04uMjUyMkQ5MkFFNjA5MDhDREE5MjQxOEY5MUZCODkwNTMmcGlkPU5ld3MiLCJ3aWR0aCI6NzAwLCJoZWlnaHQiOjM1MH19LCJwcm92aWRlciI6W3siX3R5cGUiOiJPcmdhbml6YXRpb24iLCJuYW1lIjoiVGhlIEJ1c2luZXNzIEluc2lkZXIifV0sIm5hbWUiOiJBcHBsZSBzdG9jayByaXNlcyBhcyBTYW1zdW5nIGJ1bmdsZXMgaXRzIGV4cGxvZGluZyBzbWFydHBob25lIHJlY2FsbCIsImFib3V0IjpbeyJyZWFkTGluayI6Imh0dHBzOlwvXC9hcGkuY29nbml0aXZlLm1pY3Jvc29mdC5jb21cL2FwaVwvdjVcL2VudGl0aWVzXC80NThmYjNlYy04MGY3LTJhNDAtMmY1ZS1lYTBiZjQ3ZmU3ZjYiLCJuYW1lIjoiU3RvY2sifSx7InJlYWRMaW5rIjoiaHR0cHM6XC9cL2FwaS5jb2duaXRpdmUubWljcm9zb2Z0LmNvbVwvYXBpXC92NVwvZW50aXRpZXNcL2NkNTUwMzkwLThmMjMtOWZhYS00YjNkLTVkNWVmNDIyYzk4OSIsIm5hbWUiOiJNYXRjaCJ9LHsicmVhZExpbmsiOiJodHRwczpcL1wvYXBpLmNvZ25pdGl2ZS5taWNyb3NvZnQuY29tXC9hcGlcL3Y1XC9lbnRpdGllc1wvNmZhNTdjMjktZTgxMy00YTFkLTdmYmEtMzU0MWNhNGMxZGMzIiwibmFtZSI6IkFwcGxlIEluYy4ifV0sImRlc2NyaXB0aW9uIjoiQXBwbGUgc3RvY2sgcm9zZSB0byAkMTE2LjIzIGluIG1pZC1kYXkgdHJhZGluZyBhcyBpdHMgbWFpbiByaXZhbCBmb3IgdGhlIGhpZ2gtZW5kIHNtYXJ0cGhvbmUgbWFya2V0LCBTYW1zdW5nLCBjb250aW51ZXMgdG8gcmVlbCBmcm9tIHJlcG9ydHMgdGhhdCBpdHMgbGF0ZXN0IGRldmljZSBjb250aW51ZXMgdG8gaGF2ZSBpc3N1ZXMgd2l0aCBpdHMgYmF0dGVyeS4gVGhlICQyLjE3LCBvciAkMS45MCUgcmlzZSwgY29tZXMgYWZ0ZXIgQXBwbGUgLi4uIiwiY2F0ZWdvcnkiOiJTY2llbmNlQW5kVGVjaG5vbG9neSIsInVybCI6Imh0dHA6XC9cL3d3dy5iaW5nLmNvbVwvY3I/SUc9RDY2OTdFNEQxMjZDNEEzMDkwMDJENkQ0MEE1RDExRDgmQ0lEPTA4MjAwMkMyNjQ0NzZENjIyNjYzMEI2ODY1NzY2Q0RGJnJkPTEmaD0xNmFlbGR2RFZxM1JJUWtid2RLZFY4dFhScTFGeFhJZ0tmaXI3dDJhTmFJJnY9MSZyPWh0dHAlM2ElMmYlMmZ3d3cuYnVzaW5lc3NpbnNpZGVyLmNvbSUyZmFwcGxlLXN0b2NrLXJpc2luZy1ub3ctbWF0Y2hlcy1kZWNlbWJlci1wcmljZS0yMDE2LTEwJnA9RGV2RXgsNTAyNS4xIn0=", "dataJsonVer" : "1.0", "sentimentString" : "Apple stock rises as Samsung bungles its exploding smartphone recall. Apple stock rose to $116.23 in mid-day trading as its main rival for the high-end smartphone market, Samsung, continues to reel from reports that its latest device continues to have issues with its battery. The $2.17, or $1.90% rise, comes after Apple ...", "targetSearchTextId" : "77", "sentimentScore" : "0.09044259", "active" : "1", "dataSourcesId" : "288", "articleTitle" : "Apple stock rises as Samsung bungles its exploding smartphone recall", "publishDate" : "2016-10-10T18:01:00", "articleAbstract" : "Apple stock rose to $116.23 in mid-day trading as its main rival for the high-end smartphone market, Samsung, continues to reel from reports that its latest device continues to have issues with its battery. The $2.17, or $1.90% rise, comes after Apple ...", "sentimentScoreVer" : "1.0"}}
{"data":[{"id":2934,"0":2934}]}
Found Id: 2934
Error Count: 0

Execution Time: 57119ms
-----Usage Report-----
Total Commands Run: 67
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: 3

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

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

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