[New Integration] Advanced Utilities



Show first post

37 replies

Userlevel 7
Badge +12

Thank you @Liz_Roberts  :D

Hi there.  

I tried the link, but I can’t find it after I get redirected.  Is this still available?

Thanks buddy!

Userlevel 7
Badge +10

@Jimwinner 

If you’re building a zap and you can’t find the app in the app selector dropdown, this is a known issue.

Refresh the page and the app should magically appear in the dropdown.

Is this safe to use. What happens when I accept the invite? 

Thanks @ikbelkirasan this is soooo useful!

I think the CSV export utility skips over empty line items in the input which is sub-optimal because it leads to variability in the number of columns, and the column order. Is there any way you could add an option to preserve empty columns?

Userlevel 7
Badge +12

Thanks @andywingrave :)

@CreekFire - Yes, it’s safe to use this integration. When you accept the invite, this integration will be added to your available integrations menu.

I’m a bit confused on the CSV file output. I’m trying to save line items as a csv.
When I run the test, it generates:

hydrate|||.eJwtjcuSgjAURP8la3nGB7gaZKTEEYtSUXRjRYiAJoRKgqCW_z444-7Wud19niBhpcSlPMp7hcEY-KAHilJIVCb4WKQdcarKMMz-0HAXvhP6X6YKVaNLJbWQjNYC87-cZY8GlmX1AEoSVneDH2ha5rAHzgUm6bFE9O1I8e14LgjuRq4N4pkA4yf4-D-cYpmztz2_pxxJxoWaYemKm_f_P9Vl2h1dr-bkHZOyEmNNe6CqwFzpDMp7SagCqoiiBytRI9SEUS0hhVIRJM-MU82wR9DQ9NB9RE14qnkQjnB4WFSrYDYTMr80a_8S5di5BBYMo7O70zetsoXtNLcNQvtti2uow_uVzkoUy8XcimU0LWoyiSFeOmb_EHr6Nt6Im2O1VRNv-6jj0_1gnXIf_Uy3p3a5vyiBiE5ePHfnq-WsmBCTHla-t8-UzN5Nblgm3zYZHEwnh-wKXq_XL-kkkHY:1rNGhW:-u8PEAyW0sOKuT6tSinhsb5JkrQ|||hydrate

I’ve no idea what this is/means/does. I’m just looking for a simple way to save some data into a csv file.

Userlevel 2

@guillermo I know I’m about 2 years late but I found a solution to my own issue with the MalformedPOSTRequest error when trying to convert a JSON string to CSV here

In a Javascript code step you need to take your JSON string and run a gnarly replace() function on it to get rid of bad characters. As soon as I did this, the CSV converter happily accepted my JSON.

jsonString.replace(/[\x80-\uffff]/g, (m) => `%${m.charCodeAt(0).toString(16).padStart(2, '0')}`)
Userlevel 1
Badge

Hi @ikbelkirasan!

Got a question, maybe you can help.

I use “Export to CSV” and “Input Type: Line Items”. I have around 50 line items and get a 400 error when testing with data that contains danish characters (æ,ø,å) in keys and values. Can you imagine a way I can get through with this? 

Weirdly, if I test with just a few line items containing danish characters, I get no errors. 

 

Userlevel 7
Badge +12

Hi @qbftech - The link still works. Maybe you need to refresh your zap editor page to access the integration. Make sure to select it in an action step.

This tool is great, thank you so much!


Is it possible to rename the file being generated?  Currently it’s coming through as “output.csv” but ideally, I’d like this filename to be unique and contain the current day’s date.

Userlevel 1
Badge

I have data that looks like this:

[{"Product":"8 \"","Quantity":"2","Flavour":"B Choc"},{"Product":"10\"","Quantity":"1","Flavour":"Lemon"},{"Product":"10\"","Quantity":"1","Flavour":"Vanilla"},{"Product":"12\"","Quantity":"2","Flavour":"Carrot"}]

It can be a variable size, this one happens to have 4 entries.

What I need is this:

Product: 8",10",10",12"

Quantity: 2,1,1,2

Flavour: B Choc,Lemon,Vanilla, Carrot

 

Can Export CSV do this?

Reply