Alteryx and XBRL

[PeggyGithinji]

Does anyone know if Alteryx supports .xbrl data formats or any workarounds in place as it doesn't seem to be one of the supported file type formats on designer. 

[Raj]

@PeggyGithinji 
as per best of my knowledge Alteryx does not support the .xbrl extension directly and you will need to run a python script to read that files.

[Raj · Accepted solution]

@PeggyGithinji 
you can try this python script
hope this helps

import pandas as pd
from xbrl import XBRLParser, GAAP, GAAPSerializer

# Load the XBRL file
xbrl_file = 'path_to_your_xbrl_file.xbrl'
parser = XBRLParser()
xbrl = parser.parse(open(xbrl_file))

# Use GAAP serializer to extract information
gaap_obj = GAAPSerializer(xbrl, 'http://fasb.org/us-gaap/2021-01-31')
data = gaap_obj.serialize()

# Convert to a DataFrame
df = pd.DataFrame(data)

# Save to CSV
df.to_csv('output.csv', index=False)

[PeggyGithinji]

Thanks @Raj will look into embedding python and see how that works! 

[apathetichell]

I believe XBRL is a syntax of XML and I'd look to processing it either in plain text or as XML. I would not use a python package which has not been updated in 8 years.