output data transformation
🖥️Platform
i need to transform fetched data (keep only some columns) , which parameters should i change. I send data to google sheet with integration. my data is like i need to transform fetched data (keep only some columns) , which parameters should i change. I send data to google sheet with integration. my data is like
[
{
"facebookUrl": "https://www.facebook.com/share/g/1DVsmsewEY/",
"text": "",
"user": {
"id": "100011462833209",
"name": "Xaliq Qarayev",
"profilePic": "https://scontent-phl2-1.xx.fbcdn.net/v/t39.30808-1/786036778_2976986569360075_549C"
},
"likesCount": 0,
"commentsCount": 0
},
}][
{
"facebookUrl": "https://www.facebook.com/share/g/1DVsmsewEY/",
"text": "",
"user": {
"id": "100011462833209",
"name": "Xaliq Qarayev",
"profilePic": "https://scontent-phl2-1.xx.fbcdn.net/v/t39.30808-1/786036778_2976986569360075_549C"
},
"likesCount": 0,
"commentsCount": 0
},
}][
{
"facebookUrl": "https://www.facebook.com/share/g/1DVsmsewEY/",
"text": "",
"user": {
"id": "100011462833209",
"name": "Xaliq Qarayev",
"profilePic": "https://scontent-phl2-1.xx.fbcdn.net/v/t39.30808-1/786036778_2976986569360075_549C"
},
"likesCount": 0,
"commentsCount": 0
},
}][
{
"facebookUrl": "https://www.facebook.com/share/g/1DVsmsewEY/",
"text": "",
"user": {
"id": "100011462833209",
"name": "Xaliq Qarayev",
"profilePic": "https://scontent-phl2-1.xx.fbcdn.net/v/t39.30808-1/786036778_2976986569360075_549C"
},
"likesCount": 0,
"commentsCount": 0
},
}]
Solution
({ datasetData }) => {
const terms = [
'olcu', 'ölçü', 'mebel', 'dest', 'dəst', '%',
'kiray', 'otaq yoldaşı', 'otaq yoldasi', '📍', '🔹', '✅'
];
return datasetData
// 1. Filter out posts containing any of the terms
.filter(item => {
if (!item.text) return true; // Keep posts that have no text
const textLower = item.text.toLowerCase();
// Returns true (keeps the post) ONLY if NONE of the terms are found
return !terms.some(term => textLower.includes(term.toLowerCase()));
})
// 2. Map the remaining approved posts to your format
.map(item => ({
"post source": item.facebookUrl || "",
"posts (alan-satan)": item.text || "",
"tarix": item.time || "",
"comments (alan-satan)": "",
"groupTitle": item.groupTitle || "",
"user": item.user?.name || item["user/name"] || "no data",
"user2": ""
}));
} ({ datasetData }) => {
const terms = [
'olcu', 'ölçü', 'mebel', 'dest', 'dəst', '%',
'kiray', 'otaq yoldaşı', 'otaq yoldasi', '📍', '🔹', '✅'
];
return datasetData
// 1. Filter out posts containing any of the terms
.filter(item => {
if (!item.text) return true; // Keep posts that have no text
const textLower = item.text.toLowerCase();
// Returns true (keeps the post) ONLY if NONE of the terms are found
return !terms.some(term => textLower.includes(term.toLowerCase()));
})
// 2. Map the remaining approved posts to your format
.map(item => ({
"post source": item.facebookUrl || "",
"posts (alan-satan)": item.text || "",
"tarix": item.time || "",
"comments (alan-satan)": "",
"groupTitle": item.groupTitle || "",
"user": item.user?.name || item["user/name"] || "no data",
"user2": ""
}));
} 
