json2xls

부분 유료
분류별 Andrii | 업데이트됨 3달 전 | Tools
모든 토론으로 돌아가기

Testing the request gives an API error.

G
GoranMandic
5년 전

When I try the JSON file conversion request, I get an error from the API: "there was an error during the conversion"
Could you please give me an example of how to send a simple JSON file to the API?

avatar
json-xls.com commented 5년 전

It’s a <code>504 Gateway timeout</code> error.<br/>
Can you send your phrases.json through contact form http://www.json-xls.com/Support ? <br/>
<br/>
Auditing requests and transactions are managed by Mashape, not by an API provider. Please ask Mashape support for a help.

avatar
json-xls.com commented 5년 전

Your screenshot has YourMashapeKey! You should NOT share it [MashapeKey] with anyone! Please regenerate YourMashapeKey or remove screenshot from comment <br/>
<br/>
You are trying to upload file, not a raw JSON. Instead of <br/>
<code>POST https://json2xls-json-xls-v1.p.mashape.com/<b>ConvertJsonRaw</b>?format=xls&layout=Auto&view=Both HTTP/1.1</code><br/>
please use<br/>
<code>POST https://json2xls-json-xls-v1.p.mashape.com/<b>ConvertJsonFile</b>?format=xls&layout=Auto&view=Both HTTP/1.1</code><br/>
See second screenshot <br/>

G
GoranMandic commented 5년 전

It is a big array, a lot of objects, maybe the conversion just takes a bit longer… I submitted a download link for the file in the form you sent.

avatar
json-xls.com commented 5년 전

You can use Fiddler tool to run HTTP request as it described here http://www.json-xls.com/api
<br />
<code>POST https://json2xls-json-xls-v1.p.mashape.com/ConvertJsonRaw?format=xls&layout=Auto&view=Both HTTP/1.1</code><br />
<code>User-Agent: Fiddler</code><br />
<code>Content-Type: application/json</code><br />
<code>Content-Length: 137</code><br />
<code>Host: json2xls-json-xls-v1.p.mashape.com</code><br />
<code>X-Mashape-Authorization: YOUR_MASHAPE_KEY</code><br />
<code></code><br />
<code>{“employees”:[{“firstName”:“John”, “lastName”:“Doe”},{“firstName”:“Anna”, “lastName”:“Smith”},{“firstName”:“Peter”, “lastName”:“Jones”}]}</code>

G
GoranMandic commented 5년 전

Hi, thanks for the help. I am having a request timeout problem now:
http://imgur.com/uelB5g4
I think I got everything right this time, the URL, the key, the headers. Do you have any idea why it’s not working?
Again, I’m sorry to be a bother, I know I’m on the basic plan which does not include support, but I’m really struggling in figuring this out. Also, All of the previous requests I made to the API are being counted even though they are of no use to me since all I’m trying to do is convert one big JSON file using this API. The subscription description says that I have 5 daily requests, but I received an email saying I used up my monthly quota. What’s up with that? I only made around 15 requests, and more than half of those resulted in an error.
Again, thanks for your patience 😃

G
GoranMandic commented 5년 전

Thanks for the quick reply. I just tried making a post request using fiddler and I receive a 415-unsupported type response.

response**

HTTP/1.1 415 Unsupported Media Type
Cache-Control: no-cache
Content-Type: application/json; charset=utf-8
Date: Wed, 19 Oct 2016 22:39:32 GMT
Expires: -1
Pragma: no-cache
Server: Mashape/5.0.6
X-AspNet-Version: 4.0.30319
X-Powered-By: ASP.NET
X-RateLimit-request-Limit: 5
X-RateLimit-request-Remaining: 1
Content-Length: 730
Connection: keep-alive

{“Message”:“The request entity’s media type ‘multipart/form-data’ is not supported for this resource.”,“ExceptionMessage”:“No MediaTypeFormatter is available to read an object of type ‘Object’ from content with media type ‘multipart/form-data’.”,“ExceptionType”:“System.Net.Http.UnsupportedMediaTypeException”,“StackTrace”:" at System.Net.Http.HttpContentExtensions.ReadAsAsync[T](HttpContent content, Type type, IEnumerable1 formatters, IFormatterLogger formatterLogger, CancellationToken cancellationToken)\r\n at System.Web.Http.ModelBinding.FormatterParameterBinding.ReadContentAsync(HttpRequestMessage request, Type type, IEnumerable1 formatters, IFormatterLogger formatterLogger, CancellationToken cancellationToken)"}

I’ve checked my JSON file for validity and minified it, it’s around 7MB. Here’s a screenshot of my request:
http://imgur.com/a/WjZtu

아래에 의견을 추가하고 토론에 참여하세요.

새 댓글을 게시하려면 로그인 / 가입
등급: 5 - 투표: 1