While you don&#39;t intend to send any other data together with the file right now, ``multipart/form-data`` would give you the possibility to add additional data later on if this is required (without breaking compatability).

Also ``multipart/form-data`` would make it possible to access the REST API directly by submitting an HTML form (see https://stackoverflow.com/a/4526286/693140).

Your API could however support both types by using the client&#39;s content type header to distinguish between them.

I get this weird error on SQL Server. And I cannot find solution in older posts. 

I have this procedure:

    create proc _upJM_SyncAll_test
    as
    begin
	    DECLARE @SQLString nvarchar(max)

	set @SQLString = N&#39;
	DELETE FROM OPENQUERY([LOCAL_MYSQL],&#39;&#39;SELECT acSubject FROM _utjm_setitemprices&#39;&#39;) where acSubject not in (select acSubject from _uvJM_SetSubj)
	DELETE FROM OPENQUERY([LOCAL_MYSQL],&#39;&#39;SELECT acSubject FROM _utjm_setsubj&#39;&#39;) where acSubject not in (select acSubject from _uvJM_SetSubj)

	update a
	set acName2 = b.acName2,
		acName3 = b.acName3,
		acAddress = b.acAddress,
		acPost = b.acPost,
		acPostName = b.acPostName, 
		acCountry = b.acCountry, 
		acVATCodePrefix = b.acVATCodePrefix,
		acCode = b.acCode, 
		anDaysForPayment = b.anDaysForPayment
	from OPENQUERY([LOCAL_MYSQL],&#39;&#39;SELECT * FROM _utjm_setsubj&#39;&#39;) a join _uvJM_SetSubj b on (a.acSubject = b.acSubject)
	where 1=1
	and (	isnull(a.acName2,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acName2,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acName3,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acName3,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acAddress,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acAddress,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acPost,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acPost,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acPostName,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acPostName,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acCountry,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acCountry,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acVATCodePrefix,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acVATCodePrefix,&#39;&#39;&#39;&#39;) OR 
			isnull(a.acCode,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.acCode,&#39;&#39;&#39;&#39;) OR 
			isnull(a.anDaysForPayment,&#39;&#39;&#39;&#39;) &lt;&gt; isnull(b.anDaysForPayment,&#39;&#39;&#39;&#39;)
	)

	insert into OPENQUERY([LOCAL_MYSQL],&#39;&#39;SELECT * FROM _utjm_setsubj&#39;&#39;) (acSubject, acName2, acName3, acAddress, acPost, acPostName, acCountry, acVATCodePrefix, acCode, anDaysForPayment)
	select b.acSubject, b.acName2, b.acName3, b.acAddress, b.acPost, b.acPostName, b.acCountry, b.acVATCodePrefix, b.acCode, b.anDaysForPayment
	from OPENQUERY([LOCAL_MYSQL],&#39;&#39;SELECT * FROM _utjm_setsubj&#39;&#39;) a right join _uvJM_SetSubj b on (a.acSubject = b.acSubject)
	where a.acSubject is null &#39;

	EXECUTE sp_executesql @SQLString;
    end


When I run procedure in management studio like this:

      exec dbo._upJM_SyncAll_test

everything is OK. I get no error, sync is working just fine. 

But when I put execute in trigger like this:

    create trigger _utrJM_SetSubj on tHE_SetSubj after insert, update, delete
    as
    begin
	    exec dbo._upJM_SyncAll_test
    end

I get this error:

&gt; Msg 8501, Level 16, State 3, Procedure _upJM_SyncAll_test, Line 54  
&gt; MSDTC on server &#39;server&#39; is unavailable.

Procedure _upJM_SyncAll_test has only 39 lines... 


MSDTC on server &#39;server is unavailable&#39;

I am working on adding a menu to a map. The menu is working fine except I noticed there is always a padding to the left no matter what CSS applied to the menu. The padding seems to be originated from (-webkit-padding-start: 40px;) and it does not want to go away. I tried to override it with `0 !important;` that didn&#39;t do anything.


After Googling found this:

[-webkit-padding-start: 40px; What it should be for IE and Firefox?][1]

However could not find anything else on how to override or make this go away. I need to have items in the menu all the way to the left. 

![enter image description here][2]


Attached is a screenshot, green area is what I am talking about and under styles you can see -webkit-padding-start: 40px;


  [1]: https://stackoverflow.com/questions/12549591/webkit-padding-start-40px-what-it-should-be-for-ie-and-firefox
  [2]: http://i.stack.imgur.com/BQ4CN.png

Get rid of -webkit-padding-start: 40px

I&#39;m creating a simple `REST API` for uploading files. From other API&#39;s I found they use &quot;`multipart/form-data`&quot; content type. But for me, it looks like &quot;`application/octet-stream`&quot; is much simpler.

If I don&#39;t intend to send any more form data with the file is there any reason to use &quot;`multipart/form-data`&quot; and not &quot;`application/octet-stream`&quot; ?

multipart/form-data vs application/octet-stream

<p>I'm creating a simple <code>REST API</code> for uploading files. From other API's I found they use "<code>multipart/form-data</code>" content type. But for me, it looks like "<code>application/octet-stream</code>" is much simpler.</p>
<p>If I don't intend to send any more form data with the file is there any reason to use "<code>multipart/form-data</code>" and not "<code>application/octet-stream</code>" ?</p>


I am newbie to python and using Python Flask and generating REST API service.

I want to check authorization header which is sent the client.

But I can&#39;t find way to get HTTP header in flask.

Any help for getting HTTP header authorization is appreciated.

How to get http headers in flask?

A lot of people are asking *&quot;What is the maximum length a **URL** can be?&quot;* but as far as I can see nobody is asking the question:

&gt; What is a safe maximum length a segment in a URL path should be?

I think this question is equally as important.

This question is a general question aimed at supporting as many systems out of the box as possible.

In C#, you can get a list of URL path segments from an incoming request, with security modules installed what is considered the maximum length a segment in a URL path can be for this scenario?

I&#39;ve read on the following page that URL path segments over 260 characters can cause problems in custom ASP.NET modules:

 - http://www.paraesthesia.com/archive/2011/08/26/long-url-path-segments-in-asp-net-routing-yield-400.aspx/

In web browsers, you type URL segments regardless of what website you visit, `/` is a URL path segment which is usually mapped to a homepage. With Internet Explorer, Chrome and Firefox being popular browsers, what is the maximum length of a URL path segment length they support?

I can see from the following resource that the maximum length of a URL path differs for different browsers and the figure is sometimes quite high:

 - https://stackoverflow.com/questions/1289585/what-is-apaches-maximum-url-length

But this is a path and not a path segment.

I&#39;m also aware that when rewriting paths, the underlying file system path length comes into play, and the ball park figure of what I can see supported is around 255 characters in a *nix OS.

Other considerations include the maximum length of a URL path segment in a database table. For instance, in MySQL a varchar column can contain up to 255 characters, but is there a case for this, are people storing segments of paths in tables in MySQL or are people storing full URL&#39;s in varchar columns? Could this mean 255 characters is too long for a URL path segment?

Is there any W3C specification on how long a URL path segment can be as I can&#39;t spot anything?

I did read the W3C specification on URI&#39;s but again I didn&#39;t spot anything of use:

 - http://www.ietf.org/rfc/rfc2396.txt

I&#39;m quite baffled that there is no set standard on what a length a URL path segment should be, so maybe I am missing something?

I&#39;m really looking for as much information as possible on what different systems support, and what is considered a safe length for a URL path segment.

What is a safe maximum length a segment in a URL path should be?

I want to upload a (single) file to a server and show the progress of the upload.

I know I can upload a file using HTTP POST. I&#39;m not familiar with web-sockets, but as I understand, binary data can also be sent that way and because web sockets are bi-directional I could get the progress of the upload.

I&#39;m not worried about older browsers so iframe&#39;s and flash solutions aren&#39;t very appealing unless there is a significant advantage in going that route.

&lt;del&gt;I&#39;m also curious as to the best server-side technology. Are their advantages to using a WSGI server like Django? Or maybe non-blocking I/O technology like Node.js? I&#39;m not asking if web framework x is better than web framework y, or server x is better than server y. But simply what the ideal technology should have in order to facility uploads in the client.&lt;/del&gt;

**Update**: *It seems like the server side does not have bearing on the technologies/API&#39;s available on the client to facilitate uploads.*

What is the best way to upload files in a modern browser

Should the `Content-Type` header be present in an HTTP request or response when there is no payload body?

Is the correct combination of HTTP headers in this case to have no `Content-Type` and a `Content-Length` of 0, or should the `Content-Type` not be present at all when the message lacks a body?

Should Content-Type header be present when the message body is empty?

I am currently working on a project that requires the client requesting a big job and sending it to the server. Then the server divides up the job and responds with an array of urls for the client to make a GET call on and stream back the data. I am the greenhorn on the project and I am currently using Spring websockets to improve efficiency. Instead of the clients constantly pinging the server to see if it has results ready to stream back, the websocket will now just directly contact the client hooray!

Would it be a bad idea to have websockets manage the whole process from end to end? I am using STOMP with Spring websockets, will there still be major issues with ditching REST?

What are the pitfalls of using Websockets in place of RESTful HTTP?

I&#39;m trying to make an HTTP post request with a JSON body :

How to be able to add an NSdictionnary to the HTTP request body.

Here is my code, it doesn&#39;t seem to work properly.


    var entry1 = Response(IdQuestion: 6510,IdProposition: 10,Time: 30)
    var entry2 = Response(IdQuestion: 8284,IdProposition: 10,Time: 30)
    Responses.append(entry1)
    Responses.append(entry2)
    
    let list = Responses.map { $0.asDictionary }
    
    let json = [&quot;List&quot;:list,&quot;IdSurvey&quot;:&quot;102&quot;,&quot;IdUser&quot;:&quot;iOSclient&quot;,&quot;UserInformation&quot;:&quot;iOSClient&quot;]
   

    let data : NSData = NSKeyedArchiver.archivedDataWithRootObject(json)

  
    NSJSONSerialization.isValidJSONObject(json)
   
    let myURL = NSURL(string: &quot;http://www.myserver.com&quot;)!
    let request = NSMutableURLRequest(URL: myURL)
    request.HTTPMethod = &quot;POST&quot;
 

     request.setValue(&quot;application/x-www-form-urlencoded&quot;, forHTTPHeaderField: &quot;Content-Type&quot;)
        request.setValue(&quot;application/json&quot;, forHTTPHeaderField: &quot;Accept&quot;)

   
    request.HTTPBody = data
    let task = NSURLSession.sharedSession().dataTaskWithRequest(request) {
        data, response, error in
        println(response)
        // Your completion handler code here
    }
    task.resume()
    



How to make HTTP Post request with JSON body in Swift

I have checked out [this][1] and [that][2]. However, my debugger looks like below.

# Failure example

[![No form data, No raw content][3]][3].

No form data, No raw content

Raw example (* Although path is different from the screen capture, both of them are unable to read post data)


    POST https://192.168.0.7/cgi-bin/icul/;stok=554652ca111799826a1fbdafba9d3ac1/remote_command HTTP/1.1
    Host: 192.168.0.7
    Connection: keep-alive
    Content-Length: 419
    accept: application/json, text/javascript, */*; q=0.01
    Origin: https://192.168.0.7
    User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36
    content-type: application/x-www-form-urlencoded; charset=UTF-8
    Referer: https://192.168.0.7/cgi-bin/icul/;stok=554652ca111799826a1fbdafba9d3ac1/smartmomentl/access-point/network
    Accept-Encoding: gzip, deflate
    Accept-Language: en-US,en;q=0.8,zh-TW;q=0.6,zh;q=0.4
    Cookie: sysauth=f15eff5e9ebb8f152e163f8bc00505c6
    
    command=import&amp;args=%7B%22--json%22%3Atrue%2C%22--force%22%3Atrue%2C%22--mocks%22%3A%22%7B%5C%22DEL%5C%22%3A%7B%7D%2C%5C%22SET%5C%22%3A%7B%5C%22dhcp%5C%22%3A%7B%5C%22lan%5C%22%3A%7B%5C%22.section%5C%22%3A%5C%22dhcp%5C%22%2C%5C%22interface%5C%22%3A%5C%22lan%5C%22%2C%5C%22ignore%5C%22%3A%5C%220%5C%22%2C%5C%22leasetime%5C%22%3A%5C%2212h%5C%22%2C%5C%22range%5C%22%3A%5C%22172.16.0.100-172.16.0.200%5C%22%7D%7D%7D%7D%22%7D
    
    HTTP/1.1 200 OK
    Access-Control-Allow-Origin: *
    Status: 200 OK
    Content-Type: text/html; charset=utf-8
    Cache-Control: no-cache
    Expires: 0
    Transfer-Encoding: chunked
    Date: Thu, 01 Jan 1970 00:09:27 GMT
    Server: lighttpd/1.4.30
    
    31
    { &quot;ctx&quot;: &quot;No such command&quot;, &quot;exitStatus&quot;: false }
    0

NOTE: (6)

# Successful example

[![Some of them are able to work][4]][4]

Differences between them I have spotted (by differentiating header contents) 

Raw example (* Although path is different from the screen capture, both of them are unable to read post data)

    POST https://192.168.0.7/cgi-bin/icul/;stok=92dea2b939b9fceb44ac84ac859de7f4/;stok=92dea2b939b9fceb44ac84ac859de7f4/remote_command HTTP/1.1
    Host: 192.168.0.7
    Connection: keep-alive
    Content-Length: 53
    Accept: application/json, text/javascript, */*; q=0.01
    Origin: https://192.168.0.7
    X-Requested-With: XMLHttpRequest
    User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36
    Content-Type: application/x-www-form-urlencoded; charset=UTF-8
    Referer: https://192.168.0.7/cgi-bin/icul/;stok=92dea2b939b9fceb44ac84ac859de7f4/remote_command/command_reboot
    Accept-Encoding: gzip, deflate
    Accept-Language: en-US,en;q=0.8,zh-TW;q=0.6,zh;q=0.4
    Cookie: sysauth=683308794904e0bedaaead33acb15c7e
    
    command=command_reboot&amp;args=%7B%22--json%22%3Atrue%7D
    
    HTTP/1.1 200 OK
    Access-Control-Allow-Origin: *
    Status: 200 OK
    Content-Type: text/html; charset=utf-8
    Cache-Control: no-cache
    Expires: 0
    Transfer-Encoding: chunked
    Date: Thu, 01 Jan 1970 00:02:46 GMT
    Server: lighttpd/1.4.30
    
    34
    { &quot;ctx&quot;: &quot;\u0022success\u0022&quot;, &quot;exitStatus&quot;: true }
    0

NOTE: (6)

# Header Difference between 2 examples

* Successful one is using [Jquery binding][jquery_ajax] while failure one using [HTTPS from nodejs][5] + browserify. However, I am still finding a way to check whether this is a problem or not (Not tested)

* Missing `X-Requested-With: XMLHttpRequest`. However, adding this header back to the request does not fix this problem (Tested)

* Capital header vs Smaller letter header field (

    * `content-type` and `Content-type`. However this difference is not the root cause for my problem as tried in [fiddle here][6] (Tested)

    * `Accept` vs `accept` (Not tested)

NOTE: (5) (7)

Still, I am not sure why the first `c` in `content-type` is in small letter case.

NOTE: (1)



# What I have tried

I have tried on Firefox with firebug. It is able to show my payload. However, it cannot parse response from the server :&#39;(

&lt;s&gt;Since the web server is running in HTTPS protocol, I cannot capture packets by wireshark. Any suggestion for debugging POST requests? Thanks.&lt;/s&gt;

Link to a [gist][gist] about debugging HTTP(s) request via command line. NOTE: (3)

# Wrapper I am using

I have wrap [this method from nodejs][5] with a promise calls. Below is a snippet show an option I have used.

    /**
     * Wraps HTTPS module from nodejs with Promise
     * @module common/http_request
     */

    var createRequestSetting = function (host, path, data, cookies) {
        return {
            method: &#39;POST&#39;,
            port:443,
            host: host,
            path: path,
            headers: {
                Accept: &#39;application/json, text/javascript, */*; q=0.01&#39;,
                &#39;Content-Type&#39;:
                    &#39;application/x-www-form-urlencoded; charset=UTF-8&#39;,
                &#39;Content-Length&#39;: Buffer.byteLength(data),
                &#39;Cookie&#39;: cookies,
            },
            rejectUnauthorized: false,
        };
    };

[Full source here][http_request_src]

NOTE: (2)


# Update

* (1) I have verified the letter `c` does not affect chrome debugger. Here is [the fiddle][6]. I have tried to mimic same request with `XMLHttpRequest` with letter `c`. I can still check form data in the debugger.
* (2) Link to the full source code
* (3) Link to a [gist from me][gist] about scripts to test HTTP(s) request
* (4) Reformat the question for readability
* (5) Examples are not using the same binding after code reviewing
* (6) Add raw header example
* (7) Add a comparison session 


[http_request_src]: http://jsfiddle.net/fpo8d5rv/

[gist]: https://gist.github.com/mondwan/d8605fe5311ce13e9573


  [1]: https://stackoverflow.com/questions/15603561/how-can-i-debug-a-http-post-in-chrome
  [2]: https://stackoverflow.com/questions/9163251/chrome-source-of-post-data
  [3]: http://i.stack.imgur.com/qJDcD.png
  [4]: http://i.stack.imgur.com/ily9e.png
  [5]: https://nodejs.org/api/http.html#http_http_request_options_callback
  [6]: http://jsfiddle.net/Uwcuz/4492/
[jquery_ajax]: http://api.jquery.com/jquery.ajax/


HTTP POST payload not visible in Chrome debugger?

Assuming a JavaScript array is posted in a form (using ajax/JQuery)
is the order in the array guaranteed?

Valid question from @Quentin
&quot;Define &#39;posted in a form&#39;&quot;

    $.ajax({
      type: &quot;POST&quot;,
      url: url,
      data: { foo: [{ name: &quot;one&quot; }, { name: &quot;two&quot; }] },
      success: success,
      dataType: dataType
    });

Expanding on the question (because of the above),
Is the array guaranteed to preserve the order on the server side?

Is a JavaScript array order guaranteed?

I want to download the file which is coming in the form of bytes from the AJAX response.

I tried to do it this way with the help of `Blob`:

    var blob=new Blob([resultByte], {type: &quot;application/pdf&quot;});
    var link=document.createElement(&#39;a&#39;);
    link.href=window.URL.createObjectURL(blob);
    link.download=&quot;myFileName.pdf&quot;;
    link.click();

It is in fact downloading the pdf file but the file itself is corrupted.

How can I accomplish this?

Download File from Bytes in JavaScript

I want to POST data from **Postman** Google Chrome extension.

I want to make 10 requests with different data and it should be at the same time.

Is it possible to do such in Postman? 

If yes, can anyone explain to me how can this be achieved?

Content Type	Original Author	Original Content on Stackoverflow
Question	levk	View Question on Stackoverflow
Solution 1 - Http	Stefan Kögl	View Answer on Stackoverflow

multipart/form-data vs application/octet-stream

Http Problem Overview

Http Solutions

Solution 1 - Http

Get rid of -webkit-padding-start: 40px

MSDTC on server 'server is unavailable'

Attributions