ExtractData - more infor on ExtractMetadata

Where can I find more information on the ExtractMetadata.
Mine is currently not working and would like to know more about this… Is it documented somewhere?

5 Likes

I also need information on this activity.

Currently I am extracting data from 3 columns

<extract>
	<row exact='1'>
		<webctrl tag='tr' />
	</row>
	<column attr='text' name='TradeId' exact='1'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='4' />
	</column>
	<column attr='text' name='LegId' exact='1'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='5' />
	</column>
	<column attr='text' name='MasterId' exact='1'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='1' />
	</column>
</extract>
  1. It looks like attr attribute for Column tag can have other values than 'text'
    Does it control the datatype in which data will be extracted?
    what are the other supported values here?

  2. What is the use of exact attribute in the row and column tag?
    what are the other expected values here, and what is their impact?

  3. the Row tag only appears when I extract more than one columns. Need more info on this.

Dear @docteam / @Sachin_Desai / @alex.stoian ,
Need your help getting some info on this

2 Likes

Hi @stephanus,

As of now we don’t have any documents having detailed information on ExtractMetaData property.

Regards
Vitan

Hi @akhi_s27

attr attribute has default datatype as ‘text’.
Changing it to any other available datatype in XML, will result output as null for that column.

Regards
Vitan

Thanks, this resolves my first query.
Can you please help with the other two queries?

fyi

Hello, anyone home from UiPath? We need documentation on this property or just remove it please.

2 Likes

@Vitan, @ahki_s27, I don’t believe the statement “Changing it to any other available datatype in XML, will result output as null for that column” is strictly true.

As shown in this post, with screenshots, attr=‘href’ and attr=‘src’ do not result in null output. And attr=‘href’ appears to be one of the defaults in the wizard.

It would be nice to have (at least) a list of the permissible attribute types. For now it appears trial and error are the order of the day.

Regards,
burque505

2 Likes

Is there any help? I have the same problem : " the Row tag only appears when I extract more than one columns. Here is an example:

I know that columns refers to element to extract, But What Row refers to?