Reading XBRL documents

[Sohana_Dinesh_Kamat_DK (Sohana Dinesh Kamat (SDK))]

Hi,
I am trying to read the xml document in the XBRL format.
I tried using the XML package, but unfortunately, it does not work as it is.
Does anyone have any experience fetching data from XBRL, my last resort is string manipulation.
Below is a snippet of data:
<xbrli:context id=“duration_only”>
</xbrli:entity>
<xbrli:identifier scheme=“http://www.abc.dk/cvr”>12345689</xbrli:identifier>
</xbrli:entity>
</xbrli:period>
</xbrli:startDate>2020-01-01</xbrli:startDate>
</xbrli:endDate>2020-12-31</xbrli:endDate>
</xbrli:period>
</xbrli:context>

I need to get the context id, start date and end date.

Thanks

[ppr (Peter | MVP)]

@Sohana_Dinesh_Kamat_DK
we cannot see all XML (use </> button for posting) but it is necessaire to handle XML Namespaces. For this have a look here:

Read from xml file

@Zlotzky Setting up the quick prototype: Variables: Handling Namespace: [grafik] ElementNames to Extract - Prototype reduced set: [grafik] Read In XML [grafik] Ensure: [grafik] Retrieval of private contact element (mandatory use of the Namespace within the name) [grafik] iterating over the list of elmentnames (ExtractNames) and reading element value: [grafik] Logs: [grafik] Find starter help here: Zlotzky.xaml (6.3 KB)

[Sohana_Dinesh_Kamat_DK (Sohana Dinesh Kamat (SDK))]

Thank you for clarifying that Peter.
Based on the solution you gave , I have tried the deserializing and fetching elements with the name “startDate” etc.
But unfortunately the response I get is an empty string.
When I try the element as “xbrli:startDate”, I get an error.
This is XBRL, where the file extension is .xml, but the structure is not the same as XML

Thanks

[ppr (Peter | MVP)]

@Sohana_Dinesh_Kamat_DK

@Sohana_Dinesh_Kamat_DK

When I try the element as “xbrli:startDate”, I get an error

will not work as : is not allowed. Thats why we are using the namespace info additonal.

@Sohana_Dinesh_Kamat_DK

fetching elements with the name “startDate” etc.

Namespaces are to use / at least to check

In case of you need further help please share with us the XML file along a description on what is to extract. Thanks

[Sohana_Dinesh_Kamat_DK (Sohana Dinesh Kamat (SDK))]

Hi Peter,

Sorry but I am getting errors / getting stuck by using the above mentioned solution.
Please find attached the XBRL document
offentliggorelse (3).xml (63.0 KB)
I have to extract the context id and date combination
Thank you so much for your help.

[ppr (Peter | MVP)]

@Sohana_Dinesh_Kamat_DK
It was processable similar as described above for handling namespaces

Variables:

Flow:

Output

Find starter help here:
XBRL_Demo1.xaml (9.6 KB)

[Sohana_Dinesh_Kamat_DK (Sohana Dinesh Kamat (SDK))]

Thank you so much