title: Consume web api in SSRS with parameter
body: <p>I am trying to consume webapi in ssrs ( XML source ). </p>
  
  <p>If will use parameter in the url (for testing purpose ) then its working really fine  for example - <a href="http://some_xyz_url.com/Api/Report/GetReport?id=7" rel="noreferrer">http://some_xyz_url.com/Api/Report/GetReport?id=7</a> . so I can consume web api in SSRS </p>
  
  <p><b>Real problem </b> - I do not know how I can pass parameter to webapi from SSRS. I tried hard but no luck. Also I have searched stackoverflow there is no question near to my requirement.</p>
  
  <p>I am using VS2012, (.net framework 4.0), SQL server 2008 (using Microsoft SQL server report builder)</p>
  
  <p>Any help really appreciated. </p>
  
  <p>I have upload the error message when I will try to pass the parameter from SSRS to webapi.</p>
  
  <p><img src="https://i.stack.imgur.com/PdZn6.png" alt="enter image description here"></p>
  
  <p><b>Updates</b></p>
  
  <p>I have tried to pass parameter but for some reason the value of parameter is always null, Even after setting the default value. ( see below the attached jpg)</p>
  
  <p><img src="https://i.stack.imgur.com/I9D8o.png" alt="enter image description here"></p>
  
  <p>and here is how I am passing the parameter </p>
  
  <p><img src="https://i.stack.imgur.com/Wc1Qi.png" alt="enter image description here"></p>
  
  <p>but still getting 404 ( but I will use hard coded Id , its working fine in browser)</p>
  
  <p>Please advise.</p>