Extract a Value from JSON during Scheduling API Workflow

I am connecting to a shopping cart (woo) via API and pull back the categories. I am building a recursive workflow to write the categories to the database.

The JSON Header has x-wp-total : 133 (see screen shot below)

This is the number of category records. I want to set that value to a parameter called “counter” to loop through the API data.

I cannot seem to extract the number to set the counter value. Should I use REGEX to extract that? It’s one of the parameters I can select, just cannot seem to set the value.


Hey,
Maybe some plugins can help you.

1 Like

I Have JSON extractor plugin installed - think that’s why I can see the headers. It should allow me to pull the value for the header parameter but so far not the case. The log is showing the column value as null.

1 Like