0 Shares 652 Views 2 Comments

Using MS SharePoint as Data Source : Part 3

Aug 22, 2016
652 Views 2
Using Sharepoint

This is the third and last part of the series: Using MS SharePoint as Data Source. In the earlier posts we learned the basics of SharePoint and the easy way to retrieve data to SharePoint list. In this post we are going to discuss the easiest way of posting data to the SharePoint list.

Posting data to SharePoint can be done in similar way but instead of Query we will use batch element in our CAML.

 

Batch element provides batch processing of commands within HTTP protocol

 

To determine the record that needs to be updated, we should use the ID column at SharePoint. ID is a default column at SharePoint list which is auto generated for each record. If you don’t see the field you can enable this at list settings.

Batch element should look like below in your request for posting data. Note that the first field name is the ID which determines which records need to be updated. Consecutive fields are the fields for which value should be updated as passed.

 

 

Rest should be straightforward as explained in the last post. Here is a generic function for your reference.

 

 

The generic functions provided in this series can be directly used in UFT and TestComplete. Tested on UFT 12.52 and TestComplete 11 with SharePoint 2010 and SharePoint 2013. Hope you enjoyed the series, let us know your feedback/Comments or questions if any.

You may be interested

UFT Patch Updates – UFT 14.03
Unified Functional Testing
1179 views1
Unified Functional Testing
1179 views1

UFT Patch Updates – UFT 14.03

Saket - Mar 11, 2018

Post the launch of UFT 14.0, there are three patch updates has been released including a number of features and enhancement. Recently Micro Focus unveiled third patch…

Setting up Web Service Automation Project
Katalon Studio
1230 views
Katalon Studio
1230 views

Setting up Web Service Automation Project

Saket - Oct 24, 2017

Web services are specific services that can be published and called over the Internet by client applications. Katalon Studio supports functional testing of web services. This topic…

Setting up Mobile Automation Project in MacOS
Katalon Studio
1042 views1
Katalon Studio
1042 views1

Setting up Mobile Automation Project in MacOS

Saket - Oct 09, 2017

Using Katalon Studio, mobile tester can design automation test for both Android and iOS to run on physical devices, cloud services and emulators. This tutorial explains how…

2 Comments

  1. Pingback: Using MS SharePoint as data source : Part 2 - Automated-360

  2. Pingback: Using MS SharePoint as data source : Part 1 - Automated-360

Leave a Comment

Your email address will not be published.

Most from this category

Join The Growing Group of 15000+ Test Automation Engineers

Signup for our newsletter and get access to free downloads, as well as tips, tricks and techniques and various test automation resources.
Name
Email Address
Secure and Spam free...