Make one API call, update multiple DB fields

[kevin4]

I’ve defined an API call that returns stringified JSON similar to what is below.

{“domain”:“ford.com”,“mozLinks”:“43849”,“mozPA”:“64”,“mozDA”:“86”,“mozRank”:“6.4”,“mozTrust”:"",“mozSpam”:"",“majesticStatReturned”:“root”,“FB_comments”:“0”,“FB_shares”:“161597”,“stumbles”:“0”,“pinterest_pins”:“19”,“majesticLinks”:“43374858”,“majesticRefDomains”:“51563”,“majesticRefEDU”:“6604”,“majesticRefGov”:“43578”,“majesticRefSubnets”:“21836”,“majesticIPs”:“35679”,“majesticCF”:“64”,“majesticTTF0Name”:“Business/Automotive”,“majesticTTF0Value”:“81”,“majesticTTF1Name”:“Recreation/Autos”,“majesticTTF1Value”:“61”,“majesticTTF2Name”:“Sports/Motorsports”,“majesticTTF2Value”:“52”,“majesticTF”:“83”}

There is a DB field created for each returned value. I see how I can get values by doing one API call per value being fetched. That looks easy. What I want is to do one API call, then update every DB field from the returned string without making another API call, as I’ve already received all the values.

I can not see how I do this.

I’m sure someone must have solved this, but in searching this forum, I found only one similar question from 2016 in which no one provided an answer.

Has anyone done this?

[Jici]

All field on one thing?
I guess that actually your API Call is set to Data. Change it (or clone it) to be "Action.
Do Action first and then make change to thing and in field use Results of step 1

[kevin4]

Thank you! Thank you! Thank you!

That worked!

[sam14]

@Jici Or @kevin4 - Can you elaborate on the solution here. I’m still stumbling on this one. Thanks so much in advance!

[kevin4]

The key is to make sure Use as is set to Action, not Data.

[sam14]

Now I get it! Thank you @kevin4!

[kevin4]

You’re very welcome.

Sometimes the English language descriptions are not precise enough.