Databases
StackOverflow2013
Postsdbo
POPOST to ASP.NET WebAPI using Fiddler2
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPOST to ASP.NET WebAPI using Fiddler2
    primarykey
    data
    text
    <p>I have a class that models exactly the entity I have in the database. I have a stored procedure that takes in parameters for a new row and returns all the settings in the table which in turn populates my repository. I am able to see the results of GET, PUT and DELETE in the List of type Setting that is in memory. I am noticing first that even when I close Visual Studio and reopen and run the project, sometimes, the List is still in the state it was before. It is not repopulating from the database so I'm not sure why that is first of all... Secondly, I can't seem to get POST to work from Fiddler unlike the other HTTP verbs. I DO see the values from Fiddler show up in the code below but I get the error: Invalid URI: The format of the URI could not be determined. I get the same error if I pass an ID or not.</p> <p>Here is what I put into Fiddler: </p> <blockquote> <p>POST localhost:54852/api/settings</p> </blockquote> <p>Request Headers</p> <pre><code>User-Agent: Fiddler Content-type: application/x-www-form-urlencoded Host: localhost:54852 Content-Length: 149 </code></pre> <p>Request Body</p> <blockquote> <p>ID=0&amp;Category=Dried%20Goods&amp;Sub_Category=Other&amp;UnitSize=99&amp;UnitOfMeasureID=999&amp;Facings=true&amp;Quantity=true&amp;EverydayPrice=999.99&amp;PromotionPrice=111.11</p> </blockquote> <p>PostSetting function within my SettingsController</p> <pre><code> public HttpResponseMessage PostSetting(Setting item) { item = repository.Add(item); var response = new HttpResponseMessage&lt;Setting&gt;(item) { StatusCode = HttpStatusCode.Created }; string uri = Url.Route("DefaultApi", new { id = item.ID }); response.Headers.Location = new Uri(uri); return response; } </code></pre> <p>Should I create a new procedure that gets the MAXID from the database and use that as the NEW ID in the line above where a new ID is created?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCuong Le
    1. USbrianhevans
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPOST to ASP.NET WebAPI using Fiddler2
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COAdding UriKind.Relative like I found in this post > http://stackoverflow.com/questions/9738174/invalid-uri-the-format-of-the-uri-could-not-be-determined-c-sharp < solved my POST issue. I am now able to see my POSTed setting. I still don't know why the local setting is help in memory. Also, I am noticing that the ID column created a new ID despite me providing a new one and that will undoubtedly ruin my PK in the underlying table. Any suggestions on saving this data back to the database?
      singulars
      1. POPOST to ASP.NET WebAPI using Fiddler2
      1. USbrianhevans
    2. COSee related answer here [http://stackoverflow.com/questions/12321350/webapi-put-call/12571866#12571866][1] [1]: http://stackoverflow.com/questions/12321350/webapi-put-call/12571866#12571866
      singulars
      1. POPOST to ASP.NET WebAPI using Fiddler2
      1. USShayne Boyer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload