Error 103 on Buy query

[hiroshi]

I'm trying call the api and getting the error 103.

Is this call correct?

https://api.empireavenue.com/shares/buy?apikey=XXXXXXXXXXXXXXX&username=USERNAME&password=PASSWORD&ticker=TICKER&shares=50&last_trade=8.03854

[Ulf Hedlund]

On Tue, Jun 28, 2011 at 11:53 PM, hiroshi <daniel...@gmail.com> wrote:
> I'm trying call the api and getting the error 103.
>

Are you using POST for the request and not GET?

[hiroshi]

Yes. POST.

I'm trying write a VBA code for excel. Others functions run ok. The
BUY don't.


On 28 jun, 19:09, Ulf Hedlund <u...@ulfhedlund.se> wrote:

[Duleepa Wijayawardhana]

Check your network traffic, I have no idea about VBA code but that definitely would be the server interpreting your request as GET instead of a POST

[hiroshi]

I think is that. Because I tried the status update call and I receive
"No data specified" error, but I tried at home and office, on vba and
php, and had success only on GET calls.
Any tip/sugestion?

On 28 jun, 19:27, Duleepa Wijayawardhana <dule...@empireavenue.com>
wrote:

[hiroshi]

Someone can send me a simple working example of a post method api call
on php or any other language?

[Kevin Umbach]

Your best bet would be to search Google for some examples or
tutorials. There are lots of php post examples out there...

Kevin

[hiroshi]

Really!?!? I hadn't tough about...

Isn't the first time I use a post on php, or yet on vba. I used to
create spreadsheets to tweet by Excel, for example, using POST and
yes, it works, .
It's really the first time I tried to use the post on php/vba on
EMPIREAVENUE API. And this, I really doesn't found so much
information .
My questions are:
The 103 error means that the post is treated as GET?
The "No data specified" error on status update means the same?

Any suggestion?

Thanks for the answers.

[kevinu]

> The 103 error means that the post is treated as GET?

No, it most likely means you are doing a GET instead of a POST as Dups has previously mentioned. 

>The "No data specified" error on status update means the same? 

No, it most likely means you are doing a GET instead of a POST as Dups has previously mentioned.

[kevinu]

Post your code and maybe someone can help you more. 

[hiroshi]

Thanks kevinu, on VBA I'm trying something simpler like this:

Sub status()

Dim xml, eUsername, ePassword, eStatus, eResult, sURL
Dim i As Integer
Dim blwExists As Boolean


Set xml = CreateObject("MSXML2.XMLHTTP")




'get the username entered by you in named range tusername
eUsername = Range("eusername")
'get the password entered by you in named range tpasswd
ePassword = Range("epassword")



sURL = "https://api.empireavenue.com/profile/set/status?
apikey=017f784073f99616341fa8f77ae730036792003cfa6fdd03aa&username=" &
eUsername & "&password=" & ePassword & "&status=Trying to use API to
send status update"


xml.Open "POST", sURL, False

xml.setRequestHeader "Content-Type", "content=text/html;
charset=iso-8859-1"
xml.Send
sHTML = xml.responsetext
Debug.Print sHTML

Set xml = Nothing

End Sub

[Ulf Hedlund]

On Tue, Jul 5, 2011 at 5:03 AM, hiroshi <daniel...@gmail.com> wrote:
>
>    xml.Open "POST", sURL, False
>    xml.setRequestHeader "Content-Type", "content=text/html;
> charset=iso-8859-1"
>    xml.Send

I'm not that familiar with VBA, but I believe you need to set the
request header to "application/x-www-form-urlencoded" when doing a
POST request:

> xml.Open "POST", sURL, False

> xml.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
> xml.Send

[Daniel Morine]

I tried

The error persists

2011/7/5 Ulf Hedlund <u...@ulfhedlund.se>

[Kevin Umbach]

I think Ulf is correct. You may also have to specify other information as well.

Here is what I'm doing in the MyEmpire iPhone app to set status. You
can see all the data that needs to be set. VBA may differ than ObjC
though.

postData is equal to the string "status=this the the status message text..."
length = length of postData string.

[request setHTTPMethod:@"POST"];
[request setValue:@"application/x-www-form-urlencoded"
forHTTPHeaderField:@"Content-Type"];
[request setValue:length forHTTPHeaderField:@"Content-Length"];
[request setHTTPBody:[postData dataUsingEncoding:NSASCIIStringEncoding]];

[Kevin Umbach]

Forgot to mention that the URL the POST is sent to is:

https://api.empireavenue.com/profile/set/status?apikey=51000000000000000000d0&username=KEVINUM&password=secret

Notice there is no "&status" parameter in the URL.

[hiroshi]

I'm still with error.

On 5 jul, 00:56, Kevin Umbach <kumb...@gmail.com> wrote:
> Forgot to mention that the URL the POST is sent to is:
>

> https://api.empireavenue.com/profile/set/status?apikey=51000000000000...

>
> Notice there is no "&status" parameter in the URL.
>
>
>
>
>
>
>
> On Mon, Jul 4, 2011 at 9:51 PM, Kevin Umbach <kumb...@gmail.com> wrote:
> > I think Ulf is correct. You may also have to specify other information as well.
>
> > Here is what I'm doing in the MyEmpire iPhone app to set status. You
> > can see all the data that needs to be set. VBA may differ than ObjC
> > though.
>
> > postData is equal to the string "status=this the the status message text..."
> > length = length of postData string.
>
> > [request setHTTPMethod:@"POST"];
> > [request setValue:@"application/x-www-form-urlencoded"
> > forHTTPHeaderField:@"Content-Type"];
> > [request setValue:length forHTTPHeaderField:@"Content-Length"];
> > [request setHTTPBody:[postData dataUsingEncoding:NSASCIIStringEncoding]];
>
> > On Mon, Jul 4, 2011 at 9:34 PM, Ulf Hedlund <u...@ulfhedlund.se> wrote: