How to run stored procedure based on query from cte, until all rows have been submited in Stored Procedure

Hi,
Firstly thank you for taking a look at my question!

Basically I have an API I need to upload data to.

Normally fairly easy, but in this instance, I need to do separate submissions based on a common field value.
for example, say I have 4 rows in a cte called "CTE_Campaign"

FileNo       Name            INTNUM
1                TEST 1          4
2                TEST 2          3
3                Test 3             4
4                Test 4              1

so using the above data, in theory there would be 3 different submissions
Campaign 1 - Intnum4
FileNo       Name            INTNUM
1                TEST 1          4
3                Test 3             4

Campaign 2 - Intnum3
FileNo       Name            INTNUM
2                TEST 2          3

Campaign 3 - Intnum1
FileNo       Name            INTNUM
4                Test 4              1

It actually helped writing it out here to make it clearer as to what I need to do, but could someone give me a bit of guidance as to how to proceed with this?

many thanks!