Notifications
Clear all
How To
7
Posts
2
Users
0
Reactions
6
Views
Topic starter
Hi everyone,
I'm looking to extract structured data from an API call to store in Airtable, specifically contact details.
My main challenge is in the initial step: processing the API's response because I'm unable to encode it as JSON.
Here's the data from the HTTP request response:
The content type is "text/html".
[
{
"statusCode": 200,
"headers": [
{
"name": "cache-control",
"value": "private"
},
{
"name": "content-type",
"value": "text/html;charset=UTF-8"
},
{
"name": "server",
"value": "Microsoft-IIS/8.5"
},
{
"name": "set-cookie",
"value": "******** I have removed this ; secure; path=/"
},
{
"name": "x-powered-by",
"value": "ASP.NET"
},
{
"name": "date",
"value": "Tue, 09 Apr 2024 04:35:36 GMT"
},
{
"name": "content-length",
"value": "2872"
}
],
"cookieHeaders": [
"***** I have removed this ***; secure; path=/"
],
"data": "{"cpage":1,"datas":[{"vcode":"10000427","FullName_e":"Dr. Dia A SMITH","FullName_k":"Dia A SMITH","Affiliation_e":"The University of Queensland ","Affiliation_k":"The University of Queensland ","Depart_k":"UQ Dow Centre and School of Civil Engineering ","Depart_e":"UQ Dow Centre and School of Civil Engineering ","mphoto":"https://evs37korea.org/file/mphoto/10000427_Main%20PP%20300x300.jpg","Title":"Dr.","favorite":false,"CountryName":"Australia"},{"vcode":"10000346","FullName_e":"Mr. SENONGWOOK CHA","FullName_k":"차성욱","Affiliation_e":"YOUNGSHIN PRECISION","Affiliation_k":"영신정공","Depart_k":"Electrification Engineering Design Team 1","Depart_e":"Electrification Engineering Design Team 1","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10002059","FullName_e":"Mr. Unyoung(David) CHAE","FullName_k":"채운영","Affiliation_e":"Y2Solution","Affiliation_k":"와이투솔루션","Depart_k":"New Business Planning","Depart_e":"New Business Planning","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10000706","FullName_e":"Ph D. JAESEUNG CHEON","FullName_k":"천재승","Affiliation_e":"Hyundai Mobis","Affiliation_k":"현대모비스","Depart_k":"FTCI","Depart_e":"FTCI","mphoto":"","Title":"Ph D.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10001914","FullName_e":"Mr. Keunsoo CHO","FullName_k":"조근수","Affiliation_e":"HYUNDAI MOTOR COMPANY","Affiliation_k":"현대자동차","Depart_k":"","Depart_e":"","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10000888","FullName_e":"Ms. Genevieve Cullen","FullName_k":"","Affiliation_e":"EDTA","Affiliation_k":"","Depart_k":"","Depart_e":"","mphoto":"","Title":"Ms.","favorite":false,"CountryName":"USA"},{"vcode":"10006368","FullName_e":"CHOI JAEGI","FullName_k":"최재기","Affiliation_e":"KOREA ELECTRIC TERMINAL","Affiliation_k":"한국단자공업","Depart_k":"","Depart_e":"","mphoto":"","Title":"","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10000598","FullName_e":"Mr. Jinwon KIM","FullName_k":"김진원","Affiliation_e":"jlab company","Affiliation_k":"제이랩","Depart_k":"","Depart_e":"","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10001845","FullName_e":"Ph D. Yeonji KIM","FullName_k":"김연지","Affiliation_e":"GMEG","Affiliation_k":"지엠이지","Depart_k":"","Depart_e":"","mphoto":"","Title":"Ph D.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10007329","FullName_e":"LEE KWANGSEOK","FullName_k":"이광석","Affiliation_e":"A-pro Industrial Co.,LTD.","Affiliation_k":"아프로산업","Depart_k":"","Depart_e":"","mphoto":"","Title":"","favorite":false,"CountryName":"Republic of Korea"}],"intTotalcount":28,"intTotalpage":3,"result":"success","vcode":"10007150"}",
"fileSize": 2872
}
]
I'm aiming for a result like this:
[
{
"vcode": "10000427",
"FullName_e": "Dr. Dia A SMITH",
"FullName_k": "Dia A SMITH",
"Affiliation_e": "The University of Queensland ",
"Affiliation_k": "The University of Queensland ",
"Depart_k": "UQ Dow Centre and School of Civil Engineering ",
"Depart_e": "UQ Dow Centre and School of Civil Engineering ",
"mphoto": "https://evs37korea.org/file/mphoto/10000427_Main%20PP%20300x300.jpg",
"Title": "Dr.",
"favorite": false,
"CountryName": "Australia"
},
{
"vcode": "10000346",
"FullName_e": "Mr. SENONGWOOK CHA",
"FullName_k": "차성욱",
"Affiliation_e": "YOUNGSHIN PRECISION",
"Affiliation_k": "영신정공",
"Depart_k": "Electrification Engineering Design Team 1",
"Depart_e": "Electrification Engineering Design Team 1",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10000706",
"FullName_e": "Ph D. JAESEUNG CHEON",
"FullName_k": "천재승",
"Affiliation_e": "Hyundai Mobis",
"Affiliation_k": "현대모비스",
"Depart_k": "FTCI",
"Depart_e": "FTCI",
"mphoto": "",
"Title": "Ph D.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10001914",
"FullName_e": "Mr. Keunsoo CHO",
"FullName_k": "조근수",
"Affiliation_e": "HYUNDAI MOTOR COMPANY",
"Affiliation_k": "현대자동차",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10000888",
"FullName_e": "Ms. Genevieve Cullen",
"FullName_k": "",
"Affiliation_e": "EDTA",
"Affiliation_k": "",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Ms.",
"favorite": false,
"CountryName": "USA"
},
{
"vcode": "10006368",
"FullName_e": "CHOI JAEGI",
"FullName_k": "최재기",
"Affiliation_e": "KOREA ELECTRIC TERMINAL",
"Affiliation_k": "한국단자공업",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10000598",
"FullName_e": "Mr. Jinwon KIM",
"FullName_k": "김진원",
"Affiliation_e": "jlab company",
"Affiliation_k": "제이랩",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10001845",
"FullName_e": "Ph D. Yeonji KIM",
"FullName_k": "김연지",
"Affiliation_e": "GMEG",
"Affiliation_k": "지엠이지",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Ph D.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10007329",
"FullName_e": "LEE KWANGSEOK",
"FullName_k": "이광석",
"Affiliation_e": "A-pro Industrial Co.,LTD.",
"Affiliation_k": "아프로산업",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10004347",
"FullName_e": "Mr. PARK KWANSUP",
"FullName_k": "박관섭",
"Affiliation_e": "Hyundai Motor Company",
"Affiliation_k": "현대자동차",
"Depart_k": "eP System Test Team 3",
"Depart_e": "eP System Test Team 3",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
}
]
When I use a "Transform to JSON" module, this is the output:
"eyJjcGFnZSI6MSwiZGF0YXMiOlt7InZjb2RlIjoiMTAwMDA0MjciLCJGdWxsTmFtZV9lIjoiRHIuIERpYSBBIFNNSVRIIiwiRnVsbE5hbWVfS19rIjoiRGlhIEFfU01JVEgiLCJBZmZpbGlhdGlvbl9lIjoiVGhlIFVuaXZlcnNpdHkgb2YgUXVlZW5zbGFuZCAsIiwgIkFmZmlsaWF0aW9uX2siOiJUaGUgVW5pdmVyc2l0eSBvZiBRdWVlbnNsYW5kICIsIkRlcGFydF9rIjoiVVEgRG93IENlbnRyZSBhbmQgU2Nob29sIG9mIENpdmlsIEVuZ2luZWVyaW5nICIsIkRlcGFydF9lIjoiVVEgRG93IENlbnRyZSBhbmQgU2Nob29sIG9mIENpdmlsIEVuZ2luZWVyaW5nICIsIm1waG90byI6Imh0dHBzOi8vZXZzMzdrb3JlYS5vcmcvZmlsZS9tcGhvdG8vMTAwMDA0MjdfTWFpbiVQcCUyMDMwMHgzMDAuanBnIiwiVGl0bGUiOiJEci4iLCJmYXZvcml0ZSI6ZmFsc2UsIkNvdW50cnlOYW1lIjoiQXVzdHJhbGlhIn0seyJ2Y29kZSI6IjEwMDAwMzQ2IiwiRnVsbE5hbWVfZSI6Ik1yLiBTRU5PTkdXT09LIENIQSIsIkZ1bGxOYW1lX2siOiLssKjshLHskqoiLCJBZmZpbGlhdGlvbl9lIjoiWU9VTkdTSElOIFBSRUNJU0lPTiIsIkFmZmlsaWF0aW9uX2siOiLsmIHiuiDsoJzrpqEiLCJEZXBhcnRfaSI6IkVsZWN0cmlmaWNhdGlvbiBFbmdpbmVlcmluZyBEZXNpZ24gVGVhbSAxIiwiRGVwYXJ0X2UiOiJFbGVjdHJpZmljYXRpb24gRW5naW5lZXJpbmcgRGVzaWduIFRlYW0gMSIsIm1waG90byI6IiIsIlRpdGxlIjoiTXIuIiwiZmF2b3JpdGUiOmZhbHNlLCJDb3VudHJ5TmFtZSI6IlJlcHVibGljIG9mIEtvcmVhIn0seyJ2Y29kZSI6IjEwMDAyMDU5IiwiRnVsbE5hbWVfZSI6Ik1yLiBVbnlvdW5nKGRhdmlkKSBDSEFFIiwiRnVsbE5hbWVfayI6ItLIw7Jp7Jq07JmBIiwiQWZmaWxpYXRpb25fZSI6IllTby1sdXRpb24iLCJBZmZpbGlhdGlvbl9rIjoi7JmD7J207Yit7Iqj7IWSIiwiRGVwYXJ0X2siOiJOZXcgQnVzaW5lc3MgUGxhbm5pbmciLCJEZXBhcnRfZSI6Ik5ldyBCdXNpbmVzcyBQbGFubmluZyIsIm1waG90byI6IiIsIlRpdGxlIjoiTXIuIiwiZmF2b3JpdGUiOmZhbHNlLCJDb3VudHJ5TmFtZSI6IlJlcHVibGljIG9mIEtvcmVhIn0seyJ2Y29kZSI6IjEwMDAwNzA2IiwiRnVsbE5hbWVfZSI6IlBoIEQuIEpBRVNFVU5HIE1FT04iLCJGdWxsTmFtZV9rIjoi7LKc7J6s7Iq5IiwiQWZmaWxpYXRpb25fZSI6Ikh5dW5kYWkgTW9iaXMiLCJBZmZpbGlhdGlvbl9rIjoi7ZiE64yA66qo67mE7IqkIiwiRGVwYXJ0X2siOiJGVENJIiwiRGVwYXJ0X2UiOiJGVENJIiwibXBob3RvIjoiIiwiVGl0bGUiOiJQaC4iLCJmYXZvcml0ZSI6ZmFsc2UsIkNvdW50cnlOYW1lIjoiUmVwdWJsaWMgb2YgS29yZWEifSx7InZjb2RlIjoiMTAwMDE5MTQiLCJGdWxsTmFtZV9lIjoiTXIuIEtldW5zb28gQ0hPIiwiRnVsbE5hbWVfayI6ItLHw7re7IiYIiwiQWZmaWxpYXRpb25fZSI6IkhZVU5EQUkgTU9UT1IgQ09NUEFOWSIsIkFmZmlsaWF0aW9uX2siOiLtmITrjIDsnpDrj5nssKgiLCJEZXBhcnRfaSI6IiIsIkRlcGFydF9lIjoiIiwibXBob3RvIjoiIiwiVGl0bGUiOiJNci4iLCJmYXZvcml0ZSI6ZmFsc2UsIkNvdW50cnlOYW1lIjoiUmVwdWJsaWMgb2YgS29yZWEifSx7InZjb2RlIjoiMTAwMDA4ODgiLCJGdWxsTmFtZV9lIjoiTXMuIEdlbmV2aWV2ZSBDdWxsZW4iLCJGdWxsTmFtZV9rIjoiIiwiQWZmaWxpYXRpb25fZSI6IkVEVEEiLCJBZmZpbGlhdGlvbl9rIjoiIiwiRGVwYXJ0X2siOiIiLCJEZXBhcnRfZSI6IiIsIm1waG90byI6IiIsIlRpdGxlIjoiTXMuIiwiZmF2b3JpdGUiOmZhbHNlLCJDb3VudHJ5TmFtZSI6IlVTQSJ9eyJ2Y29kZSI6IjEwMDA2MzY4IiwiRnVsbE5hbWVfZSI6IkNIT0kgSkFFR0kiLCJGdWxsTmFtZV9rIjoi7LWc7J6s7rCsiLCJBZmZpbGlhdGlvbl9lIjoiS09SRUEgRUxFQ1RSSUMgVEVSTUlOQUwiLCJBZmZpbGlhdGlvbl9rIjoi7LWp7J6s7rCsiLCJEZXBhcnRfaSI6IiIsIkRlcGFydF9lIjoiIiwibXBob3RvIjoiIiwiVGl0bGUiOiIiLCJmYXZvcml0ZSI6ZmFsc2UsIkNvdW50cnlOYW1lIjoiUmVwdWJsaWMgb2YgS29yZWEifSx7InZjb2RlIjoiMTAwMDA1OTgiLCJGdWxsTmFtZV9lIjoiTXIuIEppbndvbiBLSU0iLCJGdWxsTmFtZV9rIjoi7rmA7KeE7JuQIiwiQWZmaWxpYXRpb25fZSI6ImpsYWIgY29tcGFueSIsIkFmZmlsaWF0aW9uX2siOiLsoJzsnbTrnqkiLCJEZXBhcnRfaSI6IiIsIkRlcGFydF9lIjoiIiwibXBob3RvIjoiIiwiVGl0bGUiOiJNci4iLCJmYXZvcml0ZSI6ZmFsc2UsIkNvdW50cnlOYW1lIjoiUmVwdWJsaWMgb2YgS29yZWEifSx7InZjb2RlIjoiMTAwMDE4NDUiLCJGdWxsTmFtZV9lIjoiUGggRC4gWWVvbmppIEtJTSIsIkZ1bGxOYW1lX2siOiLquYDsl7Dsp4AiLCJBZmZpbGlhdGlvbl9lIjoiR01FRyIsIkFmZmlsaWF0aW9uX2siOiLsp4Dsl6DsnbTsp4AiLCJEZXBhcnRfaSI6IiIsIkRlcGFydF9lIjoiIiwibXBob3RvIjoiIiwiVGl0bGUiOiJQaC4iLCJmYXZvcml0ZSI6ZmFsc2UsIkNvdW50cnlOYW1lIjoiUmVwdWJsaWMgb2YgS29yZWEifSx7InZjb2RlIjoiMTAwMDczMjkiLCJGdWxsTmFtZV9lIjoiTEVFIEtXQU5HU0VPUSIsIkZ1bGxOYW1lX2siOiLsnrTqta3riJzsiJzEiLCJBZmZpbGlhdGlvbl9lIjoiQS1wcm8gSW5kdXN0cmlhbCBDby4sTFRIuIiwiQWZmaWxpYXRpb25fayI6IuyVhO2UhOuhnOyCsOyXhSIsIkRlcGFydF9rIjoiIiwiRGVwYXJ0X2UiOiIiLCJtcGhvdG8iOiIiLCJUaXRsZSI6IiIsImZhdm9yaXRlIjpmYWxzZSwiQ291bnRyeU5hbWUiOiJSZXB1YmxpYyBvZiBLb3JlYSJ9XSwiaW50VG90YWxjb3VudCI6MjgsImludFRvdGFscGFnZSI6MywicmVzdWx0Ijoic3VjY2VzcyIsInZjb2RlIjoiMTAwMDcxNTAifQ==
If I first use an "HTML to Text" module and then attempt to parse it as JSON, I get this:
"{"cpage":1,"datas":[{"vcode":"10000427","FullName_e":"Dr. Dia A SMITH","FullName_k":"Dia A SMITH","Affiliation_e":"The University of Queensland ","Affiliation_k":"The University of Queensland ","Depart_k":"UQ Dow Centre and School of Civil Engineering ","Depart_e":"UQ Dow Centre and School of Civil Engineering ","mphoto":"https://evs37korea.org/file/mphoto/10000427_Main%20PP%20300x300.jpg","Title":"Dr.","favorite":false,"CountryName":"Australia"},{"vcode":"10000346","FullName_e":"Mr. SENONGWOOK CHA","FullName_k":"차성욱","Affiliation_e":"YOUNGSHIN PRECISION","Affiliation_k":"영신정공","Depart_k":"Electrification Engineering Design Team 1","Depart_e":"Electrification Engineering Design Team 1","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10002059","FullName_e":"Mr. Unyoung(David) CHAE","FullName_k":"채운영","Affiliation_e":"Y2Solution","Affiliation_k":"와이투솔루션","Depart_k":"New Business Planning","Depart_e":"New Business Planning","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10000706","FullName_e":"Ph D. JAESEUNG CHEON","FullName_k":"천재승","Affiliation_e":"Hyundai Mobis","Affiliation_k":"현대모비스","Depart_k":"FTCI","Depart_e":"FTCI","mphoto":"","Title":"Ph D.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10001914","FullName_e":"Mr. Keunsoo CHO","FullName_k":"조근수","Affiliation_e":"HYUNDAI MOTOR COMPANY","Affiliation_k":"현대자동차","Depart_k":"","Depart_e":"","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10000888","FullName_e":"Ms. Genevieve Cullen","FullName_k":"","Affiliation_e":"EDTA","Affiliation_k":"","Depart_k":"","Depart_e":"","mphoto":"","Title":"Ms.","favorite":false,"CountryName":"USA"},{"vcode":"10006368","FullName_e":"CHOI JAEGI","FullName_k":"최재기","Affiliation_e":"KOREA ELECTRIC TERMINAL","Affiliation_k":"한국단자공업","Depart_k":"","Depart_e":"","mphoto":"","Title":"","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10000598","FullName_e":"Mr. Jinwon KIM","FullName_k":"김진원","Affiliation_e":"jlab company","Affiliation_k":"제이랩","Depart_k":"","Depart_e":"","mphoto":"","Title":"Mr.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10001845","FullName_e":"Ph D. Yeonji KIM","FullName_k":"김연지","Affiliation_e":"GMEG","Affiliation_k":"지엠이지","Depart_k":"","Depart_e":"","mphoto":"","Title":"Ph D.","favorite":false,"CountryName":"Republic of Korea"},{"vcode":"10007329","FullName_e":"LEE KWANGSEOK","FullName_k":"이광석","Affiliation_e":"A-pro Industrial Co.,LTD.","Affiliation_k":"아프로산업","Depart_k":"","Depart_e":"","mphoto":"","Title":"","favorite":false,"CountryName":"Republic of Korea"}],"intTotalcount":28,"intTotalpage":3,"result":"success","vcode":"10007150"}"
According to ChatGPT, this is valid JSON, but I'm unable to utilize the data in subsequent modules; it's treated as a large block of text.
I need to iterate through the contact data and save it into Airtable.
Does anyone have suggestions on how to accomplish this?
PS: I have already managed to extract the data using Google Sheets and ChatGPT's scripting capabilities, so I'm not in a rush. My primary goal is to understand how to perform this task within callin.io, as I'm currently stuck.
Posted : 09/04/2024 4:53 am
Welcome to the callin.io community!
In your HTTP module settings, under the “Parse response” field, select “YES” (it is set to “No” by default).
This action will enable you to map the response collection properties (variables) in subsequent modules.
Posted : 09/04/2024 5:08 am
Topic starter
Hello,
Thank you for the quick response! I wanted to mention that I've already attempted that, and it doesn't seem to be having the desired effect:
If I configure it like this:
The outcome is as follows:
{
"cpage": 1,
"datas": [
{
"vcode": "10000427",
"FullName_e": "Dr. Dia A SMITH",
"FullName_k": "Dia A SMITH",
"Affiliation_e": "The University of Queensland ",
"Affiliation_k": "The University of Queensland ",
"Depart_k": "UQ Dow Centre and School of Civil Engineering ",
"Depart_e": "UQ Dow Centre and School of Civil Engineering ",
"mphoto": "https://evs37korea.org/file/mphoto/10000427_Main%20PP%20300x300.jpg",
"Title": "Dr.",
"favorite": false,
"CountryName": "Australia"
},
{
"vcode": "10000346",
"FullName_e": "Mr. SENONGWOOK CHA",
"FullName_k": "차성욱",
"Affiliation_e": "YOUNGSHIN PRECISION",
"Affiliation_k": "영신정공",
"Depart_k": "Electrification Engineering Design Team 1",
"Depart_e": "Electrification Engineering Design Team 1",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10002059",
"FullName_e": "Mr. Unyoung(David) CHAE",
"FullName_k": "채운영",
"Affiliation_e": "Y2Solution",
"Affiliation_k": "와이투솔루션",
"Depart_k": "New Business Planning",
"Depart_e": "New Business Planning",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10000706",
"FullName_e": "Ph D. JAESEUNG CHEON",
"FullName_k": "천재승",
"Affiliation_e": "Hyundai Mobis",
"Affiliation_k": "현대모비스",
"Depart_k": "FTCI",
"Depart_e": "FTCI",
"mphoto": "",
"Title": "Ph D.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10001914",
"FullName_e": "Mr. Keunsoo CHO",
"FullName_k": "조근수",
"Affiliation_e": "HYUNDAI MOTOR COMPANY",
"Affiliation_k": "현대자동차",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10000888",
"FullName_e": "Ms. Genevieve Cullen",
"FullName_k": "",
"Affiliation_e": "EDTA",
"Affiliation_k": "",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Ms.",
"favorite": false,
"CountryName": "USA"
},
{
"vcode": "10006368",
"FullName_e": "CHOI JAEGI",
"FullName_k": "최재기",
"Affiliation_e": "KOREA ELECTRIC TERMINAL",
"Affiliation_k": "한국단자공업",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10000598",
"FullName_e": "Mr. Jinwon KIM",
"FullName_k": "김진원",
"Affiliation_e": "jlab company",
"Affiliation_k": "제이랩",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Mr.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10001845",
"FullName_e": "Ph D. Yeonji KIM",
"FullName_k": "김연지",
"Affiliation_e": "GMEG",
"Affiliation_k": "지엠이지",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "Ph D.",
"favorite": false,
"CountryName": "Republic of Korea"
},
{
"vcode": "10007329",
"FullName_e": "LEE KWANGSEOK",
"FullName_k": "이광석",
"Affiliation_e": "A-pro Industrial Co.,LTD.",
"Affiliation_k": "아프로산업",
"Depart_k": "",
"Depart_e": "",
"mphoto": "",
"Title": "",
"favorite": false,
"CountryName": "Republic of Korea"
}
],
"intTotalcount": 28,
"intTotalpage": 3,
"result": "success",
"vcode": "10007150"
}
This data is still not accessible in subsequent modules as individual objects:
Posted : 09/04/2024 5:26 am
Hmm… It appears the external API isn't returning valid JSON.
Could you please share the API's URL and a screenshot of your HTTP module's configuration?
Posted : 09/04/2024 7:41 am
I successfully utilized the Parse JSON module with the provided URL to transform the string into usable variables.
Posted : 09/04/2024 2:27 pm
Topic starter
Hi there,
Yes, it functions correctly when using Parse JSON. I was previously using Transform to JSON, and for some reason, it wasn't working.
Thank you for your quick responses!
Posted : 11/04/2024 5:50 am