# Switch-off API enrichment while in dev mode

**URL:** <https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764>\
**Category:** Feature Requests\
**Tags:** Building-Flows\
**Created:** [July 7, 2020, 7:40am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764 "2020-07-07T07:40:28Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [July 7, 2020, 7:40am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/1 "2020-07-07T07:40:28Z")

</div>

This request is subsequent to this [post](https://community.parabola.io/t/stop-calculating-for-api-enrichment/761).

1. What is your feature/integration request?

For API enrichment I would like to be able to switch-off calculation while in dev mode.

1. What problem would this feature/integration solve?

It would not waste credit on usage-based API services.

1. How do you solve/workaround this problem today?

No workaround satisfy my requirements.

In the same objective, it would be nice if we could tick something to ignore blank cells.

---

<div class="post-metadata">

**Author:** ![Vincent\_Paugam](https://avatars.discourse-cdn.com/v4/letter/v/bcef8e/32.png) [@Vincent\_Paugam](https://community.parabola.io/u/Vincent_Paugam)\
**Post date:** [July 8, 2020, 3:48pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/2 "2020-07-08T15:48:48Z")

</div>

Would be very useful !

---

<div class="post-metadata">

**Author:** ![Alexis\_Aubert](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@Alexis\_Aubert](https://community.parabola.io/u/Alexis_Aubert)\
**Post date:** [July 10, 2020, 8:01am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/3 "2020-07-10T08:01:43Z")

</div>

What a wonderful idea!!!

---

<div class="post-metadata">

**Author:** ![Sebastian\_Schaeffer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sebastian_schaeffer/32/967_2.png) [@Sebastian\_Schaeffer](https://community.parabola.io/u/Sebastian_Schaeffer)\
**Post date:** [September 23, 2020, 4:01pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/4 "2020-09-23T16:01:48Z")

</div>

Agreed! my flow does 2000 api calls with each run and whenever i change something (often unrelated to the api call) I will burn thousands of API credits just for some minor change. This is getting somewhat expensive 😭

---

<div class="post-metadata">

**Author:** ![Annika\_Cederblad](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@Annika\_Cederblad](https://community.parabola.io/u/Annika_Cederblad)\
**Post date:** [October 29, 2020, 3:11am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/5 "2020-10-29T03:11:44Z")

</div>

I think my issue is related to this: I am using the enrich feature to create new customers and use the response in my next flow to write their new IDs back in a different system. Because the enrich step actually runs while you are editing the flow, my customer is created but the response with the ID is gone when I try to publish & run the whole flow since the customer already exists

---

<div class="post-metadata">

**Author:** ![Gustavo\_Dias](https://avatars.discourse-cdn.com/v4/letter/g/cab0a1/32.png) [@Gustavo\_Dias](https://community.parabola.io/u/Gustavo_Dias)\
**Post date:** [December 12, 2020, 3:51pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/6 "2020-12-12T15:51:57Z")

</div>

I just setup a “Pull from API” step which will go through 520 pages and has a limit of 3 pages per minute. Now, I’m sitting here waiting for 2,5 hours for the “calculating…” to be over. So I can run the flow, which will take another 2,5h…

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [January 4, 2021, 2:44pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/7 "2021-01-04T14:44:01Z")

</div>

At the moment I use limit rows to only have a few.  
But at the moment of publishing I need to remove that step and it means a minimum of twice the API calls necessary for the flow…

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [January 4, 2021, 3:08pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/8 "2021-01-04T15:08:26Z")

</div>

I guess your issue is that the workflow of Parabola needs to finish calculating the step during edit mode.

If I may, I think an on/off switch as follows:  
_**Build mode: simulate step results for whole dataset using [number dropdown] API results.**_  
and eventually a refetch of these results on request.

If activated, the step would query _n_ results and randomly use those results as API response for the rest of the table during editing. Doing so, your whole flow process isn’t disturbed and we keep our API credits.

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [April 24, 2021, 12:14pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/9 "2021-04-24T12:14:48Z")

</div>

Is there any update on this?  
Losing 19k Google Places requests just to be able to save my edits…

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [April 26, 2021, 4:37pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/10 "2021-04-26T16:37:33Z")

</div>

Hi @Joachim_Brindeau,

Thanks for checking back in. There are no updates as of yet!

Our team has been busy making some major site and performance improvements, but we know this is a highly requested feature.

Once we have an update, I’ll be sure to follow up with additional information.

Really appreciate your patience here.

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [April 27, 2021, 10:16am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/11 "2021-04-27T10:16:54Z")

</div>

Thanks

Do you have any idea for a workaround (at least for runs after the first one)?  
I’m trying to figure out a way. I was thinking this:

1. Detect empty cells in columns x,y,z.
2. If any of those are empty, push these rows (and these rows only) to API enrichment.
3. Rebuild complete table.

Or simply put: “enrich if column [user input] is empty”

Thanks

---

<div class="post-metadata">

**Author:** ![Adam\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_r/32/2207_2.png) [@Adam\_R](https://community.parabola.io/u/Adam_R)\
**Post date:** [April 27, 2021, 5:29pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/12 "2021-04-27T17:29:33Z")

</div>

Hi @Joachim_Brindeau,

Great question! I just suggested a workaround in this new [community post](https://community.parabola.io/t/enrich-with-api-for-only-certain-rows/1768). Feel free to reply with any questions in the new thread!

---

<div class="post-metadata">

**Author:** ![Brandon\_Tedder](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@Brandon\_Tedder](https://community.parabola.io/u/Brandon_Tedder)\
**Post date:** [June 15, 2021, 7:59pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/13 "2021-06-15T19:59:59Z")

</div>

Yes being able to turn off API calls during dev is crucial for anyone consuming API enrichments that cost them credits. Essentially you end up paying for 2 x the consumption.

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [July 18, 2021, 3:39pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/14 "2021-07-18T15:39:04Z")

</div>

Hello, any progress?  
I want to implement API enrichment like dropcontact, serp APIs, etc. but they all work with credits.  
Thanks for your great tool

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [July 19, 2021, 7:51am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/15 "2021-07-19T07:51:19Z")

</div>

If I may suggest a solution :  
You could create a buffer between Parabola and the API we are querying.

User makes a new or revised API call = buffer forwards it to the API and saves the result.  
User makes same API call = buffer does not forward the call and returns the saved result.

I’m not a developer but something like that would spare all the credit wasted.  
Thanks

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [July 19, 2021, 7:39pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/16 "2021-07-19T19:39:58Z")

</div>

Hi @Joachim_Brindeau,

Thanks for checking in! Thanks for the suggestion as well. We don’t have any updates on this end, but we do know it’s a highly requested feature. I’ll be sure to keep you posted!

Are you able to make a request once, save the response, and then insert the JSON blob into an “Insert Text Column” step?

It’s a static workaround, but your data will be able to flow between the steps allowing you to complete your flow without using the “Enrich with an API” step. Once the template is set up, you could swap the “Enrich with an API” step back into your flow.

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [July 21, 2021, 8:08pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/17 "2021-07-21T20:08:10Z")

</div>

Thanks a lot for answering but I really struggle to understand.  
Could you detail the steps one by one please?

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [July 21, 2021, 9:45pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/18 "2021-07-21T21:45:14Z")

</div>

Sure thing!

**Step 1**  
Make a request to your API using the “Enrich with an API” step. Your first row will likely contain a JSON blob in a cell. Copy it to your clipboard.

```auto
{
  "object": {
    "a": "b",
    "c": "d",
    "e": "f"
  },
  "array": [
    1,
    2
  ],
  "string": "Hello World"
}

```

**Step 2**  
Disconnect the “Enrich with an API” step. Add an “Insert text column” step. Give your new column a name (I recommend using the same name returned from the API), and paste that JSON blob into the `Column value` field.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/7/72201a5ab6efc0b35e0bd6d2c20ee0393b29cb09.png)

**Step 3**  
Use the Expand JSON step to parse your data.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/8/8529ec959da9bdf5ea328da68b51714a80a5e5bb.png)

You can now continue to process your data while building your flow. When you’re ready to publish your flow, connect the “Enrich with an API” step and remove the “Insert text column” step.

Let me know if that helps!

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [July 22, 2021, 12:00pm UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/19 "2021-07-22T12:00:57Z")

</div>

Ah yes, unfortunately that didn’t help because I am wasting credits on errors.  
I am enriching a 4k list of company numbers and whenever one is not found, I have to filter it out in the step prior and start the requests all over again.  
So your idea is good to make edits to the flow, but without an ignore error step and/or a buffer like I described, I won’t be able to use Parabola to enrich.  
So I am currently looking at Phantombuster to enrich the output of Parabola (means an additional subscription though).

But thanks a lot for the help!

---

<div class="post-metadata">

**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\
**Post date:** [October 8, 2021, 6:47am UTC](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764/20 "2021-10-08T06:47:19Z")

</div>

Hello,

I just wanted to know if this is on the product roadmap.  
Otherwise, does anyone know a no-code alternative to parabola to enrich row by row a google sheet?

I’m a big fan of Parabola, the Webflow integration is the most irreplacable tool for me, all I need is to stop wasting all of my API credits. 😁

Joachim

[Next page](https://community.parabola.io/t/switch-off-api-enrichment-while-in-dev-mode/764.md?page=2)
