Error while loading data into staging table

[miro2]

Hi folks, 

In Data Source I have a csv file that comes from the integration. Now I want to load the data into the staging table, but I get an error.
What kind of delimiter should I use to get fields in the staging table like id, name, type, usersIDS and their values.

Or maybe is the other way to solve this.

Thank you in advance!

example.csv

{
"d" : {
"results" : [
{
"__metadata" : {
"uri" : "https://xxxxxxxxxxxx", "type" : "xxxxxxxxxxxx"
}, "id" : "345345", "flag" : 0, "name" : "Test 0", "type" : "admins", "usersIDS" : "5645hff"
}, {
"__metadata" : {
"uri" : "https://xxxxxxxxxxxxxxx", "type" : "xxxxxxxxxxxx"
}, "id" : "879789", "flag" : 0, "name" : "Test 1", "type" : "enduser", "usersIDS" : "jkjj664"
}, {
"__metadata" : {
"uri" : "https://xxxxxxxxxxxxxxxx", "type" : "xxxxxxxxxxxx"
}, "id" : "4535332", "flag" : 0, "name" : "Test 2", "type" : "admins", "usersIDS" : "fhg566h"
}
], "__next" : "https://xxxxxxxx"
}
}

[Kashyap G]

Hi @miro2 

Did you try opening this file in excel, I don't see the formatting is correct in the example that you have provided.

(This looks like more of a JSON)

Can you please attach the example excel file (if possible) here?

Regards,

Kashyap G

[miro2]

Hi @Kashyap G 
You are right, in the csv file we are storing response body (json) that comes from the integration.
The file comes from the step REST and is saved as an attachment directly in Data source.

[Kashyap G]

Hi @miro2 

There is a possibility to parse JSON on the data source directly.

Is it possible to send JSON file instead of CSV extension to the instance?

I'm not sure on why the file is sent in csv format although we have JSON inside it.

Regards,

Kashyap G

[miro2]

Hi @Kashyap G 
Could you share the way how to parse JSON on the data source directly?

I changed file extension to json right now.

I don't have JSON format here