Error: Invalid CSV provided during upload.msg= There are too few coloumns

[PiyushJain]

Hi Team,

Before starting my issue/ error. Please refer below workflow connection.  My workflow connection is as below: 

Datasource: 1) Database  2) .Json file

These 2 data sources are connected through Bitbucket. 

Macro Container: This Container connected through. .Json and sql file and after preprocessing  workflow, this macro container  creates one .csv file.

  THEN macro container used to pull/ proceed data and published report to some reporting portal with the help of predefined API.

Now the issue is:

I am able to get expected records from sql. 

But when workflow reached to Macro container..it falied with below error.

status: 400,status reason : bad request

Message: Invalid csv provides during upload

Msg= There are too few coloumns

Also able to see /n are added to the end of a each row by the macro .

Please help me to undersatnd / resolve the issue.

Regards

Piyush J

[mceleavey]

@PiyushJain ,

this looks as if the .csv is not in the correct format, in that the columns headers do not correctly correspond to the columns when the rows are parsed out.

Try loading in the .csv with \0 as the delimiter and uncheck the "First Row Contains Field Names" box:

This will allow you to load in the data as a raw file and manually parse it, which will get around the error.

Hope this helps,

M.

[PiyushJain]

Hi M,

Thanks for your reply, but the .Csv in not a data source and this csv is a part of macro enabled workflow. 

So i can't see the .csv file.

Whatever i need to do, i need to do in data coming from database  ( as per my understanding)

Please reply. 

Thank's 

Piyush J

[PiyushJain]

Hi M/ Team,

Now i realize, i am geeting below error in multifield formula tool

" Formula: tried to apply string operator to numeric value ( REPLACE)".

My expressions is as below:

Replace ( [ _CurrentField_] ,' ' ,'T')

Please help to understand the meaning of that and how to resolved that.

Regards 

Piyush J