Importing Tables or Figures from excel to DNG via API

[ElectricalDepression]

So I (or mostly GPT) have managed to make a script that parses an excel file and imports all artifacts and attributes into DNG. I was wondering if anyone knew a good way to do this for images or tables that are in excel? When I tried importing tables I just got raw HTML in the Primary Text, and images I haven't had any luck with.
Thankful for any help!

[barny]

Hi

Tables: never tried this, but I'd expect the PUT or POST to update the primary text to include the XHTML for the table as an XML literal. Try creating a table in DN then GET the artifact context and that's what you'll have to do with the table content you want to put into an artifact.

Images: sorry don't know this is possible.

Regards
Ian

[barny]

See under 'Creating Artifracts' here, except that doesn't show including the configuration - use either parameter oslc_config.context or header Configuration-Context. https://jazz.net/library/article/1197

[barny]

ah as you deleted previous response it looks like you got it working?

[ElectricalDepression]

Ah no it was just that when actually posting the xhtml it just showed up as actual headers instead of the raw text so I deleted it as it didn't really add much I thought. Ok so instead of creating an artifact directly from the excel table I create like an empty artifact and then update it with the table contents?
It seems weird because when creating the artifact for the table, for a split second the artifact has a long row as when you have a large image or table in the "primary text", then it disappears.

[barny]

I guess yes creating the artifact first the updating it with the xhtml should owkr - but if you can get this to work then it should be possible to use POST to create an artifact with the content already there. But as I say I've never tried this so can't advise further than that.

[ElectricalDepression]

Yeah I'll try to see if that works, otherwise it may just not be feasible. Thank you for your help! :)