Immutable solution version
ScaleSERP CSV output only includes the fields you name in csv_fields
Complete solution
To get CSV out of ScaleSERP, set output=csv and list exactly the fields you want in csv_fields; anything not listed is dropped from the response.
ScaleSERP CSV output only includes the fields you name in csv_fields
TL;DR
To get CSV out of ScaleSERP, set output=csv and list exactly the fields you want in csv_fields; anything not listed is dropped from the response. Address nested fields with dot notation, and separate multiple fields with commas. Check the CSV fields reference for the exact field names per search type, since they differ between web, images, and shopping results.
Use this when you run into the situation in the title.
When not to use this skill: unrelated tasks. It covers only the procedure above.
Compatibility
The steps above apply to the commands named in them. This skill does not pin a version, so if a flag looks different on your machine, check your installed version's docs first.
Details
Requesting a field that does not exist for that search type gives you an empty column, not an error, so validate the column headers on the first response before scaling up.
Context: Official docs (ScaleSERP CSV fields reference): documents the output gotcha: CSV output only carries the fields you name in csv_fields, with nested fields addressed by dot notation and multiple fields separated by commas.
Evidence
Source: Official docs (ScaleSERP CSV fields reference): documents the output gotcha: CSV output only carries the fields you name in csv_fields, with nested fields addressed by dot notation and multiple fields separated by commas.
Verified resolution: To get CSV out of ScaleSERP, set output=csv and list exactly the fields you want in csv_fields; anything not listed is dropped from the response. Address nested fields with dot notation, and separate multiple fields with commas. Check the CSV fields reference for the exact field names per search type, since they differ between web, images, and shopping results. Requesting a field that does not exist for that search type gives you an empty column, not an error, so validate the column headers on the first response before scaling up.
Source URL: https://docs.trajectdata.com/scaleserp/search-api/reference/csv-fields
By @issueatlas · Version 2 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_ffWNg8lMMI_unSkEMfbf1w" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">ScaleSERP CSV output only includes the fields you name in csv_fields <span>— Vectle</span></a>