1T - CSV Creator 3.0

@eli

Just wanted to ask - did I come across an error?

Or maybe I’m just misunderstanding how to extract lists.

There are 2 lists to extract and I followed documentation.

Extract as CSV

But I get this error:

Extract as CSV Error

It works when there is only one nested list to extract but when there is 2, it throws that error.

Am I misunderstanding something?

Have you tried using the simple lat/lon decimal value of the location like 41.40338, 2.17403?

You need to include the use as JSON-safe operator on all your values. Something in the value is breaking the JSON.

Thank you Eli. :slight_smile:

Hey @eli ,

First of all, tks for your amazing plugin!

I have a filed with a list of text, like this:
{
“key”:“value”,
“key”:“value”
}

And I facing some problems to create a CSV with the Action “Create CSV from JSON”.

When I use the list of text inside a Input, It works, but when I try to do it direct in the Action, It not works.

See the image below to illustrate the issue.

After solving this, I’ll do it inside the backend WF, as the print below:

Could you help me to understand where I’m doing some mistake?!

Thanks man!

1 Like

In the not-working scenario you used [ ] around the JSON which might break the plugins function. At least this difference is clearly visible from your screenshots.

Not working scenario is getting JSON from a table selected from the dropdown where the is add. Second scenario is getting JSON from the multi input.

Its printing the same…

Has anyone run into this issue and found a good solution?

" Workflow error - Plugin action inputs too large, should be less than 6 MB"

Encountering this on “Create CSV from JSON (SSA)”

The JSON is 5mil characters long, so it does make sense its hitting that 6MB limit, I’m just wondering if there is a simple way to sidestep this?

Cheers!

i guess you should look into hosting your own api or lambda function to do that then

1 Like

Yeah im assuming ill need something with accepts pagination to avoid maxing out the JSON limits

Hey @eli
Is there a way to perform calculations between two columns already defined in a JSON structure? For example, something like this:

{
  "Amount": "",
  "Amount Discounted": "",
  "Total": "Amount + Amount Discounted"
}

Thanks!

IIRC, nope

Hi and first of all totally awsome plugin!

Quick question, is there a way to add mora than 25 columns to an csv download?

Again, thanks for the plugin (it has really saved me tons of time)

Currently stumped on how to achieve my desired output.

This is how I want it to look:

Reading through the various posts, I determined that my setup should look like this:

However, this does not work as the JSON is broken:

{
"Total Sales": 2,
"Gross Profit": 2,
"Net Profit": 2,
"Turnover": 2,
{
 "Product Name":  "Test Product 123567865768",
"Category": "Games & Board games",
"Quantity Sold": 4

},{
 "Product Name":  "Strawberry Cupcake",
"Category": "Toys & Games",
"Quantity Sold": 10

},{
 "Product Name":  "trhrth",
"Category": "Games & Board games",
"Quantity Sold": 3

}}}

I presume because there is an object being inserted after the “Turnover” key.

I could of course include everything with the :format as text portion, but ideally I’d rather not as it doesn’t look great at all.

Can anyone offer insight as to how to solve?

Thanks,

**EDIT Ok I realised that I had curly braces in the :Format as text contents, hence why an additional object was being inserted, so I removed those so that it now looks like this:

However this has sprung up a new issue in that only one row of data is being output in the CSV - I guess because its overwriting the row on each iteration of the list items.

So beginning to think it isn’t possible to output a CSV in the format I want to?

1 Like

Hi, I can’t see the video too. can you help?