Search found 37 matches

by w.bromley
Wed Nov 20, 2024 10:48 am
Forum: Flows
Topic: Sorting a CSV before processing?
Replies: 7
Views: 7817

Re: Sorting a CSV before processing?

Huh yeah you're right - what a weirdly specific place to be adding spam links to things!!
by w.bromley
Wed Nov 20, 2024 9:49 am
Forum: Flows
Topic: Sorting a CSV before processing?
Replies: 7
Views: 7817

Re: Sorting a CSV before processing?

What do you mean scam part? The weird geometry dash bit at the end?
by w.bromley
Wed Nov 13, 2024 1:04 pm
Forum: Flows
Topic: Sorting a CSV before processing?
Replies: 7
Views: 7817

Re: Sorting a CSV before processing?

This looks absolutely perfect - I will have a play!

Thank you both!!
by w.bromley
Wed Nov 13, 2024 12:06 pm
Forum: Flows
Topic: Sorting a CSV before processing?
Replies: 7
Views: 7817

Sorting a CSV before processing?

Hi Guys! Just wondering if anyone has come up with a way (or could think of a way) to reorder a CSV based on something super simple such as column X descending. Basically, the data is "grouped" in such a way that would make it far easier for our fulfillment guys if it was in order (think d...
by w.bromley
Wed Aug 14, 2024 3:05 pm
Forum: Flows
Topic: CSV => line by line API calls
Replies: 9
Views: 11131

Re: CSV => line by line API calls

Jan's suggestion was perfect - I have the workflow basically build and already thinking of ways to roll it out to other use cases!!!

Thanks everyone for your help :)
by w.bromley
Tue Aug 13, 2024 10:30 am
Forum: Flows
Topic: CSV => line by line API calls
Replies: 9
Views: 11131

Re: CSV => line by line API calls

I cant seem to attach - invalid format - I will paste below! CSV: Name,Age,Location Alice,30,New York Bob,25,San Francisco Charlie,35,Los Angeles XSL: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transfo...
by w.bromley
Tue Aug 13, 2024 9:21 am
Forum: Flows
Topic: CSV => line by line API calls
Replies: 9
Views: 11131

Re: CSV => line by line API calls

Speaking to support it seems like Saxonica often causes issues - they have recommended I try it via the CLI rather than use the actual element!
by w.bromley
Mon Aug 12, 2024 5:18 pm
Forum: Flows
Topic: CSV => line by line API calls
Replies: 9
Views: 11131

Re: CSV => line by line API calls

Ahhh excellent - I will give that a try!!!

Cant get Saxonica working at all - got a simple demo csv and xsl and it's just erroring every time... :(
by w.bromley
Mon Aug 12, 2024 4:43 pm
Forum: Flows
Topic: CSV => line by line API calls
Replies: 9
Views: 11131

CSV => line by line API calls

Hi Guys! I have a use case whereby I need to take a supplied CSV and make an API call based on each line. I guess I need to either load in each line as either attached XML or private data and then use that to populate my API call... I am struggling with the first part of this... A suggestion I has w...
by w.bromley
Fri Feb 10, 2023 4:15 pm
Forum: Flows
Topic: API auth token
Replies: 7
Views: 6073

Re: API auth token

Brilliant - thank you!! I suspect whoever the first person who asks Tharstern to build the app will have to foot the integration bill... I did ask if they had one and their response was more or less "why - you have an API?". I think we are getting there with this... So should I be okay to ...
by w.bromley
Fri Feb 10, 2023 3:33 pm
Forum: Flows
Topic: API auth token
Replies: 7
Views: 6073

Re: API auth token

Hi freddyp, Thanks for your response. Yes after looking into it a bit more this does seem standard - just seemed like an odd way to go about it on first look. We are in the process of switching over to Tharstern - they done have an app unfortunately. If I ran with your suggested method I would need ...
by w.bromley
Fri Feb 10, 2023 12:21 pm
Forum: Flows
Topic: API auth token
Replies: 7
Views: 6073

Re: API auth token

Sorry for the ignorance - how would that help? From what I understand that app looks like it's just a tool for running command/shell stuff?
by w.bromley
Fri Feb 10, 2023 11:26 am
Forum: Flows
Topic: API auth token
Replies: 7
Views: 6073

API auth token

Hi Guys! Been working on a few bits with extracting orders from XML to inject into the API for our new MIS. I have all the data read in as metadata and so can reference it to use for the HTTP requests. The API uses some weird auth method - where you pass username and password as parameters which the...
by w.bromley
Fri Feb 10, 2023 11:24 am
Forum: Flows
Topic: Copying files to network locations
Replies: 1
Views: 2013

Re: Copying files to network locations

Hi Matt!

I have had this issue a couple of times in the past - I think the solution was to have an Output Hierarchy as the final item that places it in the desired folder.

Have a try - I think that seemed to solve it for me?
by w.bromley
Thu Feb 09, 2023 5:45 pm
Forum: Flows
Topic: XML to either CSV or API call?
Replies: 4
Views: 3036

Re: XML to either CSV or API call?

Hi!

Thanks for your help on this!

Managed to bodge an existing XLST app and mapping we have for something else...

Splits the order nodes out into individual XML files which I can then use downstream for API calls :)

Thanks again for your help!!!!!