{"id":457,"date":"2017-04-11T06:35:28","date_gmt":"2017-04-11T01:05:28","guid":{"rendered":"https:\/\/www.psoftsearch.com\/interview-questions\/?p=457"},"modified":"2017-04-11T06:35:28","modified_gmt":"2017-04-11T01:05:28","slug":"no-rows-exist-for-the-specified-keys","status":"publish","type":"post","link":"https:\/\/www.psoftsearch.com\/interview-questions\/no-rows-exist-for-the-specified-keys\/","title":{"rendered":"No rows exist for the specified keys"},"content":{"rendered":"<p>I have a Component Interface that I call from a Webservice to return some details of an Employee.<br \/>\nEMPLID is the only Find Key for the CI.<br \/>\nThe Webservice used Basic Authentication and the permission list tagged to the user has full access to the CI.<br \/>\nAlso, data corresponding to a particular employee is present in the system.<\/p>\n<p>However, when the Webservice tries to invoke the CI, it throws and error: No rows exist for the specified keys.<br \/>\nHow would you go about solving this issue?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have a Component Interface that I call from a Webservice to return some details of an Employee. EMPLID is the only Find Key for the CI. The Webservice used Basic Authentication and the permission list tagged to the user has full access to the CI. Also, data corresponding to a particular employee is present [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[],"_links":{"self":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts\/457"}],"collection":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=457"}],"version-history":[{"count":1,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts\/457\/revisions"}],"predecessor-version":[{"id":458,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/posts\/457\/revisions\/458"}],"wp:attachment":[{"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.psoftsearch.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}