API problem when setting extlink

60 views

Skip to first unread message

Darren Aitcheson

unread,

Oct 20, 2014, 9:16:52 AM10/20/14

to com_ka...@googlegroups.com

My scenario - we receive notification emails where we don't control the format.

Therefore, I have to run some VBA from within Outlook to extract the title for my cards, and also extract a hyperlink to be set at the external link on the card.

The important part of my VBA looks like this:

Set xml = CreateObject("MSXML2.XMLHTTP")

xml.Open "POST", "http://kanbanize.com/index.php/api/kanbanize/create_new_task/boardid/6/title/" & strTitle & "/extlink/" & strLink, False

xml.setRequestHeader "apikey", "{removed]" * Removed my real API key from here *

xml.Send

Unfortunately this returns an error from the API, even though I've URL encoded strLink - the error message is below.

Any ideas on how I can make this work?

Thanks!

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">

<title>404 Not Found</title>

</head><body>

<h1>Not Found</h1>

<p>The requested URL /index.php/api/kanbanize/create_new_task/boardid/6/title/RITM00115026/extlink/https://xxx.xxx.com//xxx.png

Request Name: xxx

Request Number: RITM00115026

Task Name: xxx

Task Number: TASK00118224

Requested By: xxx

Requested For: xxx

Click here to view Task: HYPERLINK "https://xxx.xxx.com/nav_to.do?uri=sc_task.do%3Fsys_id=8285a6fea1ff65c03ef8ba895636618a%26sysparm_stack=sc_task_list.do%3Fsysparm_query=active=true"TASK00118224

Note: This is an automatic task notification message.

Thank you.

Ref:MSG18968908 was not found on this server.</p>

<hr>

<address>Apache/2.4.6 (Ubuntu) Server at kanbanize.com Port 8080</address>

</body></html>

Darren Aitcheson

unread,

Oct 20, 2014, 11:00:25 AM10/20/14

to com_ka...@googlegroups.com

Found the solution.

Passing the extlink in JSON format in the request body worked.

Reply all

Reply to author

Forward

0 new messages