[AccessD] A2003: POST a set of params to a Web Resource Second Send

Darren - Active Billing darren at activebilling.com.au
Wed Jul 10 18:52:52 CDT 2019


Hi Ryan

Many thanks for the response.

I'm not too bringht and this looks like 'real' programming to me and I don't really do much these days. 

This was a request from a friend, & I thought would be a simple HTTP post or run from a batch file.

Would you know how to get that string below to run in a batch file? <grin>

Many thank in advance
 
Darren. 
 

On 11/7/19, 9:36 am, "AccessD on behalf of Ryan W" <accessd-bounces at databaseadvisors.com on behalf of wrwehler at gmail.com> wrote:

    There’s a vba-tools set of modules out on GitHub to accomplish this. 
    
    https://github.com/VBA-tools
    
    Sent from my iPhone
    
    > On Jul 10, 2019, at 6:25 PM, Darren - Active Billing <darren at activebilling.com.au> wrote:
    > 
    > Posting again – not sure the first one got through
    > 
    > 
    > 
    > -------------------
    > 
    > 
    > 
    > Howdy all,
    > 
    > 
    > 
    > How would I get the following string to be POSTed to a web site using VBA?
    > 
    > 
    > 
    > This is the final and formatted string that works when sending the CURL request via a Terminal session
    > 
    > 
    > 
    > curl -XPOST -H "Content-type: application/json" -d '{"text": "This is the Task Name for Task No: 4","description": "This is the Description for Task No: 4","dueDate": "2019-10-07"}' 'https://hooks.workast.app/1234567890’
    > 
    > 
    > 
    > The following also worked form a terminal al screen
    > 
    > 
    > 
    > curl 'https://hooks.workast.app/1234567890’ -XPOST -H "Content-type: application/json" -d '{"text": "This is the Task Name for Task No: 4","description": "This is the Description for Task No: 4","dueDate": "2019-10-07"}' 
    > 
    > 
    > 
    > Even getting it into a batch file and being able to execute it would be enough
    > 
    > 
    > 
    > Any ideas? 
    > 
    > 
    > 
    > I tried to modify some code I got from Stuart (ages ago) but no success. I have no clue …that’s why 😊
    > 
    > 
    > 
    > FYI: Workast is a site that allows for the addition of tasks for staff to review – Simple enough but can’t get the POSTing bit from Access to work
    > 
    > 
    > 
    > Many thanks in advance
    > 
    > 
    > 
    > Darren
    > 
    > 
    > 
    > -- 
    > AccessD mailing list
    > AccessD at databaseadvisors.com
    > http://databaseadvisors.com/mailman/listinfo/accessd
    > Website: http://www.databaseadvisors.com
    -- 
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
    





More information about the AccessD mailing list