Transform Map not showing Target table I want

[Mitchell Moses]

I am trying to mass subscribe 400+ user to a communities forum by taking excel file in with their names and then (through script i guess) add them to the forum in the sn_actsub_subobject_stream table, but I can't use the sn_actsub_subobject_stream as a target table. So how am I supposed to subscribe these people to this forum without having to do a ton of approvals, etc. I was just hoping to write a transform to make it easy. 

[Tony Chatfield1]

Hi,

I am not familiar with 'sn_actsub_subobject_stream' table but
You can normally use 'glide' to create records in a table via a before transform script, and then set the individual tranform row\record to ignore so that the transform does not process it - assuming the access rights and functionality that underpin the table allow you to insert records?

[Mitchell Moses]

Yep, that's what I am trying to do. I thought that was the table, but I am going to try the sn_communities_members table now. It actually will allow me to transform onto it. It's hard doing stuff for communities there isn't a lot of use case examples on here to reference 

[Tony Chatfield1 · Accepted solution]

One extra thought, is the table part of a scoped app?
You may need to be within the scope before you can access the table via transform.

[Mitchell Moses]

That actually is a great thought  and this is a scoped app. I will be thinking about that, but I'm hoping that sn_communities_members table is it (for now) Thank you so much