ronmwhite
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Empty CSV File With Header Row
I was just looking at this oddly enough. It is a simple POC I built for another team. The issue was that, sometimes, the object was not updated in Salesforce since the last run and returned null. So, uncheck “Ignore Empty Result” in the Salesforce Read, make sure the Mapper is Null Safe, and have the Router look for your key value. If it finds it, carry on as normal. If it does not, parse the object keys and write with the constant as I posted prior.1.4KViews0likes0CommentsRe: Empty CSV File With Header Row
For others whom happen to search for this as I just did. The router approach is still required as far as I can tell for the “No Data” condition, but, an easier way to write a header only file is to parse your JSON and use a Constant with a File Writer. For example, the following will get a list of Keys from your JSON (headers) as an array, turn it into a string, then, remove the opening and closing brackets. JSON.stringify(Object.keys($)).replace(“[”,“”).replace(“]”,“”) You can drop that into a Constant Snap and write to file. Works well for this case.4.2KViews0likes4CommentsReplace All Case Insensitive Based on Incoming Value
Hello. I am having some issues getting “replace” to work the way I want; kindly have a look. This works: $Name.replace(/ron/gi, “Ronald”) So does this: $Name.replace($OldName, $NewName) But, I want the above to also work with the “gi” option but it does not, e.g.: $Name.replace(/$OldName/gi, $NewName) Has anyone handled this before? If so, kindly share your solution. Thanks.Solved2.6KViews0likes2CommentsRe: Maven Install Authentication Error
@ptaylor I got the build to succeed. To do this, I removed my local Maven (downloaded from Apache originally) and added it again via brew install maven . That did not work by itself. But then, I changed my JAVA_HOME from adoptopenjdk-11.jdk to the jdk that came with Maven as part of the Brew install - Open JDK 14.0.1. When I did that, mvn clean install -DskipTests=true worked. Perhaps JDK 14 is somehow required by Maven 3.6.3 (Brew seems to think so in any case). Regardless, thanks for the support here. Note, the Snap Development Documentation still references JDK 8. I am assuming that Adopt Open JDK 11 will work for development tho as that is what we had to install on our snaplex for 4.22 recently. Let me know if you have any thing to add on that or any additional questions. Thanks again.953Views0likes1Comment