Remove formatting - API Export | Product Q&A

Remove formatting - API Export

Hello there,

I have the following issue with the content we’ve put into Collibra. When I add a Text type attribute in Collibra (for ex : the OOTB Description attribute), Collibra adds automatically some HTML formatting (even when I remove it by clicking on the proper button ). This is transparent in Collibra and should not be an issue, the users will only see the attribute without the html tags…

BUT if I want to export a domain into an Excel file, all the HTML tags reappear. I can force the export by checking the “remove formatting” button in the DGC interface and it’s working great. But is this feature available when I do the export via API ?

I currently use the Output Module to select a TableViewConfig and then export it in a CSV file, but I didn’t see any option to remove the formatting. Can it be done ?

Also, is there a way to modify the type of the characteristic, by checking the “Plain text” attribute ? I think this new attribute appeared recently, but we can’t modify it once a characteristic is created. This is mildly infuriating !

Thanks for your inputs !

prasantththulasithas

Posted 5 years ago · Edited 1 year ago·Last reply 4 years ago

3 comments

prasantththulasithas

OP5 years ago · Edited

Answering to myself, in case there are others are having the same issue.

You can remove the formatting when using the Output module API, by putting this code :

"ViewConfig":{
      "Resources":{
        "Community":{
            "Id":{
              "name":"communityId"
            },
            "Name":{
              "name":"communityName"
            },
            "Description":{
              "name":"communityDescription",
              "stripHtml":true
            }
        }
      }
  }

Here the description attribute is clean from formatting (via the “stripHtml”:true line of code). I think you should put this for every text attribute though !

I’m still looking for a way to change a Text characteristic to a Plain text characteristic…

arthurburkhardt

·5 years ago · Edited

WOW, @prasantth.thulasithas ! This is so rare that someone do this for the benefit of the community!
There are so many threads ending with “never mind, figured out it out”, that you deserve a special badge! There’s no flair here, but here you go:

sukantasahana

·4 years ago · Edited

Hi , Did you face it while using Bulk Import API , html tags are stripped from input text fields into Collibra asset attribute. Any way to stop this stripping and have all tags in text field (such as description)