VBA (Microsoft Access) Functions programming: HTTP Post, SOAP 1.2

General task description

Programming Functions in Visual Basic for Applications to interact with Web Application ‘Textkernel Sourcebox’. The required Functions include interfacing with web pages and SOAP 1.2 web interface. The interfacing has to be done against Sourcebox, a web service that parses candidate CV’s and delivers the extracted information in a XML file. Detailed technical specifications are available in the document ‘Sourcebox Interfacing Guide’ (see attachment). A test account for testing will be provided.

General specifications

- VBA Module with specified functions, programmed in Access 2013, Database Format .mdb (Access 2003 Database format)

- HTTP Post etc. realized with [login to view URL] library

- Using Microsoft Internet Explorer

- Error handling included

- Code contains comments

Specification of required functions

Login and presenting Sourcebox Application Main Screen in Internet Explorer

Function TKNLogin(account as string, username as string, password as string)

- Simply log in an present Sourcebox Main screen in Internet Explorer

Upload and process a CV in any supported source Format

Function TKNUpload(Filename as string, account as string, username as string, password as string)

- Log on if necessary, if already session exists using actual JSESSIONID

- Upload CV File (HTTP Post) and present the extractions result page (result-view) in Internet Explorer

Download structured XML Output

Function TKNDownload(XMLFilename as string, Fotofilename as string)

- Simulating pressing store button on result-view page

- Download and save result XML file according parameter XMLFilename (example: C:\temp\[login to view URL])

- Save candidate picture under Fotofilename (example: C:\temp\[login to view URL]). The picture (if available) is part of the result XML (<profilepicture>, base64content)

Upload and process a CV in any supported source format, download structured XML Output without Sourcebox web screens, using SOAP 1.2 Web Interface.

This Function make the whole process without using web Screens.

Function TKNProcess(Filename as string, account as string, username as string, password as string, XMLFilename as string, Fotofilename as string)

Log out

Function TKNLogout()

- Simply log out

Skills: PHP, Software Architecture

See more: access soap, access vba http post, web programming using php, web programming guide, visual basic programming software, visual basic programming service, visual basic programming code, visual basic in programming, visual basic for applications, temp service, structured programming, string programming, service database access, programming web pages, programming web applications, programming in visual basic, programming in vba, programming in access database, programming in access, programming guide

About the Employer:
( 4 reviews ) Stettlen, Switzerland

Project ID: #5367410

Awarded to:


Hi Markus, The specs are clear enough and I had a look at the Sourcebox API docs. The only point I am not clear about is where does IE come into use. The API allows direct HTTP protocol to send and receive data for More

$722 USD in 10 days
(48 Reviews)

9 freelancers are bidding on average $600 for this job


Hi, I (Myself a senior PHP programmer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very More

$773 USD in 20 days
(54 Reviews)

Hi, I have great experience in SOAP and website data extraction using [login to view URL] i have done the extraction of many sites like [login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL] and man More

$777 USD in 10 days
(359 Reviews)

I am Krunal K. Doshi from Ahmedabad, having 10+ years of experience in web and windows development. We work on Microsoft technologies and Open source technologies. I have a team of skilled programmers who are capable More

$533 USD in 12 days
(31 Reviews)

Hello! I have 8 years experience in programming. I know VBA and Access well. I can make this project for you. Everything will be done according to your requirements.

$350 USD in 10 days
(9 Reviews)

Greetings!!! We are glad to bid on your project and would be more happy if get a chance to work on the same. Please see PMB for details. Thanks Sonali@TeamUnipixel

$526 USD in 15 days
(2 Reviews)

we are not just a freelancer, we are a start up company, we take care of our every client personally and has always long term relationship and we have an excellent team with experience of designers that have more than More

$611 USD in 10 days
(5 Reviews)

Hello, We have vast Experience on Website Developing as we are in the market from last 3+ years. We have Sufficient and Well trained Employee Team including Website Developers, Web Designers, SEO Team. We have re More

$555 USD in 15 days
(10 Reviews)

1. very good [login to view URL] access have vba , ... 3. -----------------etc justcall me .......................

$555 USD in 10 days
(0 Reviews)