Python external Api for Shipping tracking number status

[Minseven]

hi guys,

I'have devellopped something like that, steps are follows:

- Source csv

- change/transform data

- python script runing (API) and adding a new column name "Delivery Status"

requirement: I don't want the script to run if it meets an "completed" delivery status in order to avoid API communication as much as possible.

The problem: as this are steps, it will always start from the beginning and do the same whole process again.

Any idea how I can tackle this?

[v-yuezhe-msft]

@Minseven,

Do you run python script to add the "Delivery Status"? If so, I am curious about that how to check the "completed" delivery status before you add this "Delivery Status" column. Could you please share source file and the code in Advanced Editor here?

Regards,
Lydia