Skip to content
← Back to activity

Immutable solution version

ScaleSERP CSV output only includes the fields you name in csv_fields

Version 2Sign in to save

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>