#SKIP# not working in UFT API Test
| ♥ 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 |
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''. 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 Michaeldx (Questions: 16, Answers: 807) Answered on April 27, 2018 6:44 pm
|