tk42
New Contributor III
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Directory Browser match on file name with spaces
Hi Rakesh, “File With Spaces.csv” does not work either, but using “File%20With%20Spaces.csv” does the trick. File???With???Spaces.csv also does the trick (as quoted expression or not), so it is clear now that it has to do with the encoding from the sftp server. TK2.9KViews0likes0CommentsDirectory Browser match on file name with spaces
I have a file called “File With Spaces.csv” and am trying to create a GLOB pattern to match it in a Director Browser. What should work does not work and what does work is not optimal in my opinion. Simply setting the File Filter to the value: File With Spaces.csv returns 0 documents. Setting the filter to: File?With?Spaces.csv returns 0 documents. Setting the filter to: File*With*Spaces.csv returns the 1 document. The fact that it will not match the exact file name is perplexing. The fact that ‘?’ has no effect is perplexing as well. At least ‘*’ works, but I find that pattern problematic and should not be necessary. I can find no where in the documentation that spaces require special handling. Anyone know of solution that does not require the use of ‘*’ for this? TK4.1KViews0likes3CommentsRe: Help Needed! Best Snap/Technique To Process Incoming Raw CSV Data
Assuming that you have a response from the api that has a field with the value as a CSV string, you can map that field to $[‘content’] in a Mapper, then use a Document to Binary Snap to convert to “binary” and then use a CSV Parser to create the JSON docs (SL documents). hope this helps. TK2KViews1like1CommentRe: Extracting file names from html
Other possible solutions: maybe a json mediaType can be requested from the web service (e.g., Accept or Content-Type headers) the html might be processed as XML: map the “entity” field to $[‘content’] and then run through Doc->Bin Snap then XML Parser Snap. I would prefer #1 over #2 as a lot (most?) of HTML is not well-formed. Cheers,3.2KViews1like0CommentsRe: Fixed Width Pipeline
Hi @wogen, You could possibly use the Pipeline Execute Snap with a collection of sub-pipelines that perform the formatting/writing. This way the PipeExec would act as the “router” and you can use a naming convention for the sub-pipelines that includes the route value to dynamically select (via expression) the sub-pipe to use. You would end up with a lot of sub-pipelines, but maintenance would be just adding a new one and naming following your convention. TK2.4KViews0likes1CommentRe: REST Using Python in Script Snap
In general you would probably want to use “urllib” and friends in Script Snap. It would be more helpful if you would describe the exact requirements/workflow you need, so that the community might be able to determine if/how you can accomplish what you need with the REST (ugh) Snaps. We use the REST (ugh) Snaps with no less than five different authentication mechanisms, at least two of which require passing an authentication token around. We do not have to resort to scripting with any of them. -TK1.5KViews0likes0CommentsRe: Performing an Action when there is no data
In the past we had used a Script Snap to detect/notify of the “nothing to do” condition. But it turns out that there are far less than 1% of our processes that the business required this information and, further, we recently discovered that no one that expressed the requirement is actually paying attention to the notifications. Short version: It’s not as big of an issue as people make it out to be. TK1.6KViews0likes0CommentsRe: REST Snap Pack: Where have you used it?
We use the “REST” Snap Pack for general HTTP work. We have internal API’s that are HTTP based and have some partners/vendors that supply/receive data over HTTP. “HTTP Snap Pack” would be a more accurate name for it - I know how Marketing folks are though. People incorrectly call any web service or api “RESTful” if it is “Not SOAP”. -TK PS Can we get the “JSON Splitter” renamed to just “Splitter”? 🙂1.5KViews0likes0Comments