#SKIP# not working in UFT API Test
Question ID: 108301
1
0

I have a couple of optional fields in my REST API test. I’m using the keyword #SKIP# in my Excel file to omit the field in the request. My problem is that the fields aren’t being omitted, instead they are just being filled with nulls.

Marked as spam
Posted by (Questions: 386, Answers: 64)
Asked on April 27, 2018 6:43 pm
49 views
Answers (1)
1
Private answer

I had the same problem and escalated to Micro Focus.

Their R&D engineer explained the root of the issue, here are the details: ''This is a limitation of the feature ''#SKIP#''. It can only take effect on the columns of which the contents are of 'text' type. Otherwise all texts will be treated as invalid values. This part of logic depends on Microsoft Excel APIs. According to the current connection parameters, the type of a column is determined by the top 8 cells (8 is the default value and it can be changed by the registry settings of the column, NOT including the header. Mixed-typed columns are considered as 'text' right away.''

The R&D engineer explained that the workaround is to make sure the type of the column is 'text', and there's two ways to change this:

1. Manually: In Excel, change the first row of values to ''Text'' or change the first item of the first column to ''Text''.
2. Registry:

HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftJet4.0EnginesExcelTypeGuessRows

Change the number to a bigger number, for example 60000. Micro Focus has now documented this in [KM03137588][1]

[1]:https://softwaresupport.softwaregrp.com/group/softwaresupport/search-result/-/facetsearch/document/KM03137588

Marked as spam
Posted by (Questions: 16, Answers: 807)
Answered on April 27, 2018 6:44 pm
0
OK we'll make the appropriate adjustments.
( at April 27, 2018 6:45 pm)
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top